Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “faitour” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
faitour103488(None) 
faitours1134261faitours
factor11911462facto_r
favour12438332fa_vour
santour737372santour
actor71116083_acto_r
amour75014853_a_mour
arbour84211333_arbour
ardour74110903_ardour
armour84411853_armour
auteur6107943_auteur
bailor83412603bailo_r
bailout9414133bailout
baiter84422553bait_er
candour104210243candour
cantor85621523canto_r
captor104914603capto_r
castor84418533casto_r
contour939973contour
crittur9315133crittur
detour778193_detour
ecotour944363ecotour
editor738663edito_r
factful1536373factful
factious13239243factious
factoid1338693factoid
factors12912133factors
factory15108353factory
factotum1542443factotum
facture12108933fact_ure
fadeout11410193fadeout
fagoter1135883fagoter
failure1035753fai_lure
fainer94717243fai_ner
fainter103611053fainter
fair76332523fai___r
fairer95212063fai_rer
fairgoer1242203fairgoer
faith115620853fait__h
faithed1437163faithed
faithful1743383faithful
faiths124610273fait_hs
fallout10313503fallout
falter94519053falt_er
famous11412393fa_mous
fantod102010033fanto_d
fantods11177623fantods
fantom112110803fanto_m
fantoms12189153fantoms
farceur12525273farceur
farther1348343farther
faster94625773fast_er
fastuous1145143fastuous
father125116713fa_ther
fatigue1144393fatigue
fatter94523213fa_tter
fattier103513463fattier
fatuous1037783fatuous
faubourg1461693faubourg
favor114712453fa_vo_r
favours13437093fa_vours
fervour1343103fervour
fetor81214533f_eto_r
fitful1256333f_itful
fitter94120033f_itter
flavour1334633flavour
flitter103413903flitter
flour84916453f__lour
foetor939563foeto_r
four76226863f___our
fractur12135573fract_ur
fraktur14153043frakt_ur
friseur1033673friseur
fritter103912773fritter
gaiter73819503gait_er
gator64416043ga_to_r
giaour735363_giaour
harbour1247053harbour
hauteur1033893hauteur
haviour1354823haviour
jailor13418573jailo_r
janitor1436483janito_r
labour84210933la_bour
manitou938463manitou_
manitous1039173manitous
pandour10408213pandour
pantoum1138703pantoum
parlour937263parlour
pastor84817483pasto_r
paviour1244623paviour
rainout7314393rainout
rancour987133rancour
raptor83912823rapto_r
rigour7258023_rigour
sailor63113753sailo_r
santoor737433santoor
santours837183santours
santur6311273sant_ur
sapour83812373sa_pour
sartor6313883sarto_r
sautoir735183sautoir
saviour1035213saviour
savour94110703sa_vour
stour54916743__stour
suitor63311053suito_r
tabour84011323ta_bour
tailor63412503tailo_r
tambour1136353tambour
tour45530383___tour
traitor7310123traito_r
valour93010373va_lour
vapour11378873va_pour
viator93211833viato_r
vigour10256803_vigour
waiter94321253wait_er
watthour1442893watthour

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271167.51617832.2
3Display Results1161160.0303866.7
 (SQL Overall)1786911167.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.