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

142 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
midsole103781(None) 
midsoles1137761midsoles
insole63515862_insole
middle103414982mid_dle
midsize1946392midsize
misdone10310862misdone
missile92815402missile
mudhole1344912mudhole
rissole739782rissole
airhole1048273airhole
aisle55223193ai_s_le
amidol9489563amid_ol_
amidols10457553amid_ols
amidone10349303amid_one
amitrole1045173amitrole
anisole71010833anisole
bedsore1057803bedsore
camisole1246173cami_sole
cineole91010003cineole
citole8311503ci_tole
console92715983console
dhole95215363__dhole
diastole947563diastole
diazole1736793diazole
diddle94915213did_dle
dipole91112853di_pole
dissolve1246103dissolve
dole56550003__d_ole
eidola737683eid_ola
fiddle113613383fid_dle
fissile10269653fissile
girasole984423girasole
hidable1399403hidable
hirsle9159573hirs_le
idle55423763_id__le
idol56818633_id_ol_
idols65514133_id_ols
imidazole2151103imidazole
indole74516053_indole
insoles73516243_insoles
isle45121703_i_s_le
istle52214713_i_stle
lisle53916723li_s_le
lissome937583lissome
madrone102812663madrone
manhole12311343manhole
mausolea1043073mausolea
maypole1446383maypole
measle83513223meas_le
meddle103312763med_dle
micelle1178343micelle
mickle143715133mi_ckle
microbe1338663microbe
midcult1246303midcult
middled123311893mid_dled
middler112712273mid_dler
middles113415303mid_dles
midge95016543mid__ge
midleg1038553mid__leg
midlife13248303midlife
midline102315103midline
midmost1246153midmost
midnoon1044683midnoon
mids76541773mids___
midship1546043midship
midsized2144733midsized
midspace1543953midspace
midst85922553mids__t
midstory1445103midstory
midsts95510053mids_ts
midtown1343673midtown
midwife16225523midwife
miggle104012113mi_ggle
mile66352563mi___le
mille75029133mi__lle
minable112315073minable
mingle93518783mi_ngle
miracle1138843miracle
misate81222693mi_sate
miscode12310413miscode
miscue10412223mi_scue
misdate101413963misdate
misdo85413183misdo__
misdoer1048633misdoer
misdoes10312493misdoes
misdrove1445433misdrove
mise66043573mi_s__e
misfile122611553misfile
misled94719313mi_s_led
mislie83219153mi_slie
mismove1437083mismove
miso67229893mi_so__
misos76523293mi_so_s
mispled12310463mi_spled
misrule939353misrule
missable12311533missable
missal84314903missal_
missals93914423missals
missel85216523missel_
missels94614813missels
missiles103015083missiles
missive122413143missive
missort9314653missort
missout9412663missout
misspoke1645413misspoke
misstyle1345273misstyle
misuse83213643mi_suse
misyoke1635823misyoke
mixable18259173mixable
mixible18195083mixible
mizzle16279993mi_zzle
modioli1045473modioli
module93011033mod_ule
moidore1056153moid_ore
mole66251833m___ole
muddle103414633mud_dle
mudholes1444873mudholes
mudsill1045163mudsill
mudstone1145553mudstone
muscle10310973m_uscle
myosote1245853myosote
oilhole1046263oilhole
outsole71013433outsole
piddle103514913pid_dle
piehole12188553piehole
pinhole122010433pinhole
pinole83218783pi_nole
pistole92414313pistole
plimsole1243663plimsole
podsol946853podsol_
podsols1056513podsols
posole8314223_posole
resole64624183_resole
ridable101412493ridable
riddle83915713rid_dle
rissoles839113rissoles
sidle65124033sid__le
slipsole1044263slipsole
sole46053673___sole
tadpole1036143tadpole
widdle113814843wid_dle
winsome1237463winsome

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.1561145455.1
2DLD Change Limit1340271427.51617832.2
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.73223110.6
 
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.