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 “faitours” 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.

106 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
faitours113426(None) 
faitour1034881faitour_
factors12912122facto_rs
favours13437092fa_vours
santours837182santours
actors81016763_acto_rs
amours83512663_a_mours
arbours93910043_arbours
ardours8368883_ardours
armours9389853_armours
auteurs7137503_auteurs
bailors93212413bailo_rs
bailouts1036613bailouts
baiters94619303bait_ers
candours11408643candours
cantors94620753canto_rs
captors113914983capto_rs
castors94919443casto_rs
contours1039653contours
critturs10374593critturs
detours858043_detours
ecotours1044463ecotours
editors839423edito_rs
factious13239243factiou_s
factoids1446243factoids
factor11911453facto_r_
factory15108343facto_ry
factotums1641923factotums
facture12108923fact_ure
factures13129023fact_ures
fadeouts1245693fadeouts
fagoters1234863fagoters
failure1035753fai_lure
failures1135163fai_lures
fainters11349693fainters
fairgoers1342013fairgoers
fairs85825443fai___rs
faithfuls1842303faithfuls
faiths124610273fait__hs
fallouts1137883fallouts
falters103916473falt_ers
famous11412393fa_mou_s
fantods11177623fanto_ds
fantoms12189153fanto_ms
farceurs13464723farceurs
fastuous1145143fastuous
fathers133916503fa_thers
fatigues1244193fatigues
fatuous1037783fa_tuous
faubourg1461693faubourg
faubourgs1541233faubourgs
favors124211403fa_vo_rs
favour12438333fa_vour_
fervours1453053fervours
fetors91014473f_eto_rs
fitters104517753f_itters
flavours1434693flavours
flitters114312173flitters
flours94414053f__lours
foetors1039763foeto_rs
fours85521493f___ours
fracturs13146313fract_urs
frakturs15163263frakt_urs
friseurs1133303friseurs
fritters113810783fritters
gaiters83516543gait_ers
gators74115833ga_to_rs
giaours834573_giaours
harbours1346923harbours
hauteurs1133733hauteurs
haviours1443843haviours
jailors14328753jailo_rs
janitors1536853janito_rs
labours9349893la_bours
manitous1039173manitou_s
pandours11317993pandours
pantoums1236713pantoums
parlours1036153parlours
pastors94119003pasto_rs
paviours1343613paviours
rainouts846913rainouts
rancours1076713rancours
raptors94213353rapto_rs
rigours8207003_rigours
sailors73213723sailo_rs
santoors837633santoors
santour737373santour_
santurs7310763sant_urs
sapours93610623sa_pours
sartors7314973sarto_rs
sautoirs834923sautoirs
saviours1154273saviours
savours10389343sa_vours
stours65015633__stours
suitors73012493suito_rs
tabours94110093ta_bours
tailors73212393tailo_rs
tambours1255873tambours
tours55325893___tours
traitors8310793traito_rs
valours10248743va_lours
vapours12277463va_pours
viators102712023viato_rs
vigours11285483_vigours
waiters104218623wait_ers
watthours1542813watthours

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621067.25020160.3
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.68623248.9
 
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.