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

146 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
isohels103539(None) 
isohel935481isohel_
isohyets1442622isohyets
isomers9310042isomers
mohels115011332_mohels
sorels63921162_sorels
ashes86230613as_he_s
bethels1238533bethels
boheas114013213_boheas
boshes114721883boshe_s
botels84815803_botels
bowels114315593_bowels
brothels13277073brothels
bushels124110713bushels
coshers123618183coshers
coshes115022783coshe_s
disbowels15113683disbowels
dishelm1335833dis_helm
dishelms1444723dis_helms
dishes104622653dis_he_s
disobeys1443683disobeys
dispels10310503dis_pels
dossels85511613dossels
dowels104813343_dowels
eschews1534553eschews
fishers134714723fis_hers
fishes125221343fis_he_s
gasohols1243723gasohols
gospels1035593gospels
grovels11427813grovels
hosels94218613_hosels
hostels103712323hostels
hotels94515523_hotels
hovels125413343_hovels
icones84616383icone_s
idols65514133ido__ls
impels10389523i_mpels
imphees1436693imphees
inchers123912523inchers
inches114419673inche_s
insoles73516243insole_s
insouls737213inso_uls
ironers74813553ironers
irones64724013irone_s
isles54220563is_le_s
islets64513083is_lets
isobars936593isobars
isocheim1543333isocheim
isocheims1663143isocheims
isochors1355673isochors
isogeny11196363isogeny
isogons8217613isogons
isohyet1345333isohyet
isolead835183isolead
isoleads944373isoleads
isologs837433isologs
isomer8310153isome_r
isopods1045573isopods
isosceles1143303isosceles
isothere1145793isothere
isotheres1246333isotheres
isotherm1344283isotherm
isotherms1444083isotherms
isseis638563is_seis
issuers746123issuers
issues648803issue_s
isthmus1243263isthmus
istles62814983istle_s
itches114916213itche_s
joshers174111593joshers
joshes165114853joshe_s
koels94613903_ko_els
kohls12437803_koh_ls
koshers144811803koshers
listels74212433lis_tels
losels64714593_losels
missels94614813mis_sels
models94216363_models
mohel104914833_mohel_
morels84820023_morels
moshers124017843moshers
moshes115222873moshe_s
motels83616903_motels
noels56418703_no_els
noshers103614333noshers
noshes96618233noshe_s
novels95512503_novels
oinomels1044513oinomels
pishers123815753pis_hers
pishes114722103pis_he_s
propels113412843propels
rowels94515453_rowels
schuls11299853_schuls
seels55632823_s_eels
sels46345983_s__els
sheals94420643_s_heals
sheas86331793_s_heas
sheds96122703_s_heds
shelf115221113_s_helf
shell84424123_s_hell
shells94319523_s_hells
sheols94614163_s_heols
shes75734353_s_he_s
shews115924713_s_hews
shiels95418923_shiels
shoals94215793_shoals
shoers94518333_shoers
shoes85429663_shoe_s
shools94919013_shools
shorls94516203_shorls
shovels13378393shovels
shuls85319713_s_huls
sighers113712183sighers
simnels976103simnels
sithens1039383sithens
sobers85218863_sobers
socles8418453_socles
soils55327983_so_ils
sokes95031423_soke_s
sokols10399093_sokols
solely93714213_solely
soles55547923_sole_s
soleus64615613_soleus
sols45448163_so__ls
sones55444143_sone_s
sorel56231443_sorel_
sorely94618013_sorely
sores55454283_sore_s
sorrels7310723_sorrels
sotols63714473_sotols
souls55127363_so_uls
sowens93613153_sowens
sowers94923443_sowers
speels85116393_speels
spiels85317953_spiels
steels64117983_steels
toshes94520103toshe_s
towels94314643_towels
trowels10358363trowels
tsores65113663tsore_s
ushers94415533us_hers
vowels124410483_vowels
wishers133215213wis_hers
wishes124920953wis_he_s
yodels104610073_yodels
yokels13488063_yokels

Search took 7 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 Limit1340271466.21621561.6
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.68526730.1
 
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.