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

133 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
miscalls123900(None) 
miscall1139651miscall_
fiscally1646072fiscally
fiscals1238002fisca_ls
mescals112911572mesca_ls
micells11107682mi_cells
misally121111062mis_ally
misbills1246082misbills
miscalled1447442miscalled
miscaller1346282miscaller
miscallers1444302miscallers
miscasts1238352miscasts
misclass1246842misclass
miskals13369772miska_ls
missals93914432missa_ls
scalls84218202__scalls
birdcalls1443393birdcalls
calls75634733___calls
catcalls1238323catcalls
cicalas1139303ci_calas
discants112912023discants
discards1238913discards
discases112014503discases
dismally1446513dismally
dismals102010243disma_ls
distally1239553distally
distills9319043distills
fiscal1139333fisca_l_
fiscalist1446573fiscalist
gingalls1096433gingalls
infalls1038943_infalls
installs858923installs
inwalls1037283_inwalls
jingalls1685333jingalls
malls76233433m___alls
marshalls1444833marshalls
masalas9312073mas_alas
mascaras1237693mascaras
mesally12119793mes_ally
mescal104113493mesca_l_
mesially13119083mesially
mesically16310093mesically
mezcals20246543mezca_ls
miauls8178713mi__auls
micas96823053mi_ca__s
micell1098193mi_cell_
micella11106833mi_cella
micelle1178343mi_celle
micelles1288833mi_celles
mickles153415003mi_ckles
midcults1343223midcults
mills75435053mi___lls
miracles1238333miracles
misacts1139353mis_acts
misadds1136303mis_adds
misaims11310113mis_aims
misallies1148383mis_allies
misallot1047003mis_allot
misallots1144533mis_allots
misbill1137033misbill_
miscalling1547863miscalling
miscarry1544473miscarry
miscast11312423misca_st
miscible1447673miscible
miscites12313783miscites
misclaim1445063misclaim
misclaims1544593misclaims
miscodes13310423miscodes
miscoins12311083miscoins
miscolor1245603miscolor
miscolors1345863miscolors
miscooks1645463miscooks
miscues11312393misc_ues
miscuts1139183misc_uts
misdates111113633misdates
misdeals1147233misdeals
misdials1137503misdials
miseases102614343miseases
miseats92815793misea_ts
misfiles133110983misfiles
mishaps1438723misha_ps
miskal123710263miska_l_
mislabels13114313mislabels
mislays12349243misla_ys
mismakes16129883mismakes
mismarks1645893mismarks
mismates121114563mismates
misnames12119883misnames
mispages13311183mispages
misparts12108173misparts
misplans1238863misplans
misplays1555543misplays
misrates101318243misrates
misrules1039383misrules
missable12311533missable
missal84314903missa_l_
missays124010253missa_ys
missels94614813mis_sels
missiles103015083missiles
misspells1343763misspells
mistakes141213413mistakes
mistrals101212633mistrals
misvalue1344683misvalue
misvalues1444683misvalues
muscadels1442623muscadels
muscatels1343443muscatels
muscats1138933musca_ts
muscles11310563musc_les
musicales1346703musicales
musically1647853musically
musicals1247103musica_ls
outcalls1038743outcalls
pascals11610013pasca_ls
pinballs1246933pinballs
pitfalls1345373pitfalls
rascally1347733rascally
rascals959663rasca_ls
recalls92613623_recalls
rescales103414573rescales
scalds94813693__scalds
scales84529313__scales
scall74420373__scall_
scalps104315233__scalps
sculls84613883__sculls
sisals63013573sis_a_ls
smalls84514123__smalls
spalls84217343__spalls
stalls64019933__stalls
ticals83214713ti_ca_ls
tincals93610653tinca_ls
upscales12155993upscales
visually1465493visually
visuals1036863visua_ls

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.420425454.8
2DLD Change Limit1461621337.56319325.9
3Display Results1331330.0462891.3
 (SQL Overall)1786911338.02922255.7
 
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.