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

175 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
fantails113969(None) 
fantail10310231fantail_
bangtails1243592bangtails
brantails1146312brantails
cantals93919572canta_ls
cattails1038552cattails
entails7912822_entails
fanatics1367182fanatics
fantailed1345562fantailed
fantasias1286992fantasias
fantasies1298852fantasies
fantasms1345632fantasms
fantasts1147112fantasts
foxtails1844582foxtails
pintails10310162pintails
rattails837132rattails
ventails1139822ventails
wagtails1244442wagtails
agnails837003_agnails
anils56326723_an__ils
annals66415923_anna_ls
antacids1148333_antacids
antas55432033_anta__s
anthill1048203_anthill
anthills1146533_anthills
antiars7314623_antiars
antics84621453_ant_ics
antis55033313_ant_i_s
anvils9219713_an_vils
assails769093_assails
attains7310983_attains
avails939693_a_vails
aventails1244993aventails
bangtail1144353bangtail_
bantams1149063banta_ms
banties94324763bant_ies
banzais1837163banzai_s
bobtails1245193bobtails
brantail1046893brantail_
camails11311753ca_mails
canals84421673can_a_ls
cantabile1346893cantabile
cantabiles1445763cantabiles
cantal84122033canta_l_
cantala94114673canta_la
cantalas104013523cantalas
cantatas103410093cantatas
cantraips13255273cantraips
cantrips12318933cantrips
captains121810573captains
cattail939183cattail_
centals94317053centa_ls
coattails1144853coattails
contains10316533contains
contrails11410543contrails
curtails10318243curtails
dentals83915393denta_ls
dentils84115583dent_ils
details84214043_details
entail61114343_entail_
entoils7810733_entoils
entrails8310163_entrails
facials123310743facia_ls
factoids1446243factoids
fails85631483f___ails
fallals103310193falla_ls
fanatic12610703fanati_c
fancies124018783fan_cies
fancily1538253fan_cily
fanfares1436773fanfares
fanfics1535173fan_fics
fangas105017203fanga__s
fannies103415643fan_nies
fantasia1197013fantasia
fantasie11117743fantasie
fantasied1395613fantasied
fantasise1296243fantasise
fantasises1395883fantasises
fantasist1288003fantasist
fantasists1385503fantasists
fantasize2196053fantasize
fantasizes2295463fantasizes
fantasm1236593fanta_sm
fantast10311703fanta_st
fantastics1544373fantastics
fantasy1336153fanta_sy
fantods11177623fant_ods
fantoms12189153fant_oms
farfals13268503farfa_ls
fastballs1444443fastballs
fatal84819373fa_ta_l_
fatalism13310493fa_talism
fatalist11314973fa_talist
fatally1339893fa_tally
fatties103018203fa_tties
fattily13379463fa_ttily
faucals12326563fauca_ls
fauteuils1242073fauteuils
fentanyls1541953fentanyls
fetials103711743f_etials
fewtrils1443203fewtrils
finalis103313663fin_alis
finals94316163fin_a_ls
finials103210153finia_ls
fishtails1543663fishtails
flails94313003f__lails
fontal9313143fonta_l_
fontanels1244063fontanels
fountains1245283fountains
foxtail1745383foxtail_
fractals1346133fracta_ls
frails93716473f__rails
frontals1146273fronta_ls
funfairs1442133funfairs
fungals11276783funga_ls
gantries91413803gantries
handrails1346513handrails
hangnails1353003hangnails
hartals10313023harta_ls
horntails12124823horntails
kantars11310033kanta_rs
lanais6316793lan_ai_s
lanitals837723lanita_ls
lantanas838263lantanas
lentils73912973lent_ils
mainsails1144853mainsails
maintains1167103maintains
mandrils1138493mandrils
mantas85725363manta__s
mantels94515043mant_els
mantids103113623mant_ids
mantis83926033mant_i_s
manuals9311223manua_ls
nails55730403__n_ails
oxtails1436383_oxtails
panties94230933pant_ies
pantile93918483pant_ile
pantiles103617163pant_iles
pantries101817393pantries
partials101911973partials
pastils94416173past_ils
pigtails1146033pigtails
pintail9311183pintail_
plantains1147493plantains
pontils9312213pont_ils
ponytails1443653ponytails
ramtils938413ramt_ils
ratals64219583ra_ta_ls
rattail737803rattail_
redtails968003redtails
renails74917263ren_ails
rentals74017483renta_ls
retails74718973_retails
ringtails1044443ringtails
sandals82715203sanda_ls
santalic1048893santalic
santalols944773santalols
santims9312603sant_ims
santirs7312963sant_irs
santols73513323sant_ols
snails64816653_sn_ails
tails55634193___tails
tantalic1048053tantalic
tantalise91210823tantalise
tantalus836373tantalus
tantaras8269543tantaras
tenails73713923ten_ails
unnails738223_unnails
vandals113211663vanda_ls
vantages12119023vantages
ventail10310453ventail_
wagtail1145043wagtail_
wantages12109023wantages
wassails1145953wassails
xanthins1846943xanthins

Search took 9 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.423422437.4
2DLD Change Limit1461621757.84318636.0
3Display Results1751750.0762302.6
 (SQL Overall)1786911758.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.