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

212 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
misfile12261155(None) 
misfiled14278651misfiled
misfiles133110981misfiles
misfire12229891misfire
missile92815401missile
fissile10269652fissile
misbill1137032misbill
miscible1447672miscible
miscite11314382miscite
misfield14265912misfield
misfired14238542misfired
misfires132210582misfires
misfit112813832misfi_t
misfits12279662misfits
misgive13339032misgive
mislie83219152misli_e
mislike132914832mislike
mislive122812692mislive
misrule939352misrule
missiles103015082missiles
missive122413142missive
mistily122612342mistily
mistime11312612mistime
mistitle1038522mistitle
aisle55223193ais__le
bastile9313913bastile
besmile1137463besmile
biofilm1444333biofilm
defile105216663_defile
disable10516433disable
disciple1346673disciple
dislike122913453dislike
distil73616433distil_
distill83011323distill
distils83015803distils
emissive1345923emissive
ensile62616473ens_ile
fictile1238023fictile
file75446643___file
fishily1637643fishily
fusile94313493fus_ile
hostile10312553hostile
infill938413_infill
isle45121703_is__le
istle52214713_is_tle
lisle53916723lis__le
maile75232223m__aile
mashie11315933mashi_e
massive12289773massive
messily12298813messily
micelle1178343micelle
mickle143715133mi_ckle
middle103414983mi_ddle
midfield15203843midfield
midlife13248303midlife
midline102315103midline
midsize1946393midsize
midsole1037813midsole
midwife16225523midwife
miffier1537023miffier
miffing16298403miffing
miggle104012113mi_ggle
mile66352573m___ile
milfoil1264383milfoil_
milfoils1343893milfoils
milkily16216553milkily
mille75029133mi__lle
millime112511403millime
milline92519113milline
minable112315073minable
mingle93518783mi_ngle
miracle1138843miracle
mirkily16266403mirkily
misaim10311853misai_m
misaimed1338093misaimed
misaims11310113misaims
misally121111063misally
misate81222693mis_ate
misbias1139083misbias
misbilled1445173misbilled
misbills1246083misbills
misbind1258273misbind
misbuild1343163misbuild
misbuilt1245093misbuilt
miscall1139653miscall
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mis_cue
misdate101413963misdate
misdefine1545513misdefine
misdial1039643misdial
misdialed1345513misdialed
misdials1137493misdials
misdid10510573misdi_d
misdone10310863misdone
misdrive1446683misdrive
mise66043583mis___e
misease92713043misease
miserly12329823miserly
misfaith1644543misfaith
misfed124113023misf_ed
misfeed13389683misfeed
misfielded1742443misfielded
misfields15223653misfields
misfiling1537223misfiling
misfitted1544963misfitted
misform1437513misform
misframe1546973misframe
misgave13298283misgave
misgiven14245903misgiven
misgives14329293misgives
misguide12145703misguide
mishit112618203mishi_t
mishits122513083mishits
miskal123710263miskal_
miskals13369763miskals
miskick1435613miskick
misled94719313mis__led
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mislived14328783mislived
mislives132912153mislives
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mismove1437083mismove
misname11119483misname
mispage12310523mispage
mispled12310463mis_pled
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrely12319613misrely
misruled1137083misruled
misrules1039383misrules
missable12311533missable
missal84314903missal_
missals93914423missals
missel85216523missel_
missels94614813missels
missies93423983missies
missileer1145583missileer
missilery1444553missilery
missilry1344653missilry
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
missives133212843missives
misstyle1345273misstyle
mistake131312623mistake
mistier93418713mistier
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistitled1246283mistitled
mistitles1147953mistitles
mistune9310653mistune
mistype14126523mistype
misuse83213643mis_use
misvalue1344683misvalue
miswrite1348923miswrite
misyoke1635823misyoke
mixable18259173mixable
mixible18195093mixible
mizzle16279993mi_zzle
mobile103613543m_obile
motile83818343m_otile
muffle14339643m_uffle
muscle10310973mus_cle
mushily152410093mushily
muskie123412543muski_e
muskily16289043muskily
muspike1536043muspike
mussily12279773mussily
mustily123613633mustily
nitrile73011373nitrile
omissible1344093omissible
omissive1345103omissive
piffle14418233pi_ffle
piscine11610973piscine
pismire1135353pismire
pistil83915073pistil_
pistils93314303pistils
pistole92414313pistole
prefile123413183prefile
profile123211153profile
refile95122373_refile
resile64627673res_ile
riffle124210233ri_ffle
rifle85518333ri_f_le
rimfire1243793rimfire
risible937923risible
riskily1436413riskily
rissole739783rissole
scissile1044623scissile
sessile739523sessile
simile83115633si_mile
smile74823923__smile
spile75230083__spile
stile54931573__stile
subfile122010503subfile
virile9313433vi_rile
visible1236923visible
visive1257873vis_ive
wispily1535653wispily

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 Limit1340272126.64020184.8
3Display Results2122120.0802650.0
 (SQL Overall)1786912127.12625075.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.