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
faitours113425(None) 
faitour1034881faitour_
factors12912122facto_rs
favours13437082fa_vours
santours837172santours
actors81016753_acto_rs
amours83512643_a_mours
arbours93910033_arbours
ardours8368873_ardours
armours9389843_armours
auteurs7137503_auteurs
bailors93212403bailo_rs
bailouts1036613bailouts
baiters94619303bait_ers
candours11408613candours
cantors94620753canto_rs
captors113914983capto_rs
castors94919433casto_rs
contours1039613contours
critturs10374593critturs
detours858033_detours
ecotours1044443ecotours
editors839423edito_rs
factious13239243factiou_s
factoids1446243factoids
factor11911453facto_r_
factory15108343facto_ry
factotums1641923factotums
facture12108923fact_ure
factures13129023fact_ures
fadeouts1245693fadeouts
fagoters1234853fagoters
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
faubourg1461683faubourg
faubourgs1541223faubourgs
favors124211403fa_vo_rs
favour12438333fa_vour_
fervours1453053fervours
fetors91014473f_eto_rs
fitters104517743f_itters
flavours1434683flavours
flitters114312173flitters
flours94414053f__lours
foetors1039753foeto_rs
fours85521493f___ours
fracturs13146303fract_urs
frakturs15163253frakt_urs
friseurs1133303friseurs
fritters113810783fritters
gaiters83516533gait_ers
gators74115823ga_to_rs
giaours834563_giaours
harbours1346903harbours
hauteurs1133733hauteurs
haviours1443833haviours
jailors14328743jailo_rs
janitors1536853janito_rs
labours9349883la_bours
manitous1039173manitou_s
pandours11317983pandours
pantoums1236713pantoums
parlours1036153parlours
pastors94118993pasto_rs
paviours1343613paviours
rainouts846913rainouts
rancours1076703rancours
raptors94213353rapto_rs
rigours8206993_rigours
sailors73213713sailo_rs
santoors837633santoors
santour737373santour_
santurs7310763sant_urs
sapours93610613sa_pours
sartors7314953sarto_rs
sautoirs834923sautoirs
saviours1154273saviours
savours10389333sa_vours
stours65015623__stours
suitors73012473suito_rs
tabours94110073ta_bours
tailors73212383tailo_rs
tambours1255863tambours
tours55325863___tours
traitors8310773traito_rs
valours10248733va_lours
vapours12277453va_pours
viators102712013viato_rs
vigours11285483_vigours
waiters104218623wait_ers
watthours1542793watthours

Search took 10 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.1561145455.1
2DLD Change Limit1461621069.39315560.7
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.59518623.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.