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

118 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
podzols193468(None) 
podsols1056511podsols
podzol1835081podzol_
podsol946852podsol_
podzolic2243412podzolic
polyols1238492polyols
pools74427702po__ols
pozole1758912po_zole
pozoles1839062po_zoles
aldols7109713ald_ols
apodous1037403apod_ous
benzols1836673benzols
borzois1835833borzois
bozos165216863bo_zo_s
codons96119463cod_ons
consols92914073consols
cools75632633co__ols
diols65521013__diols
dodoes85716103dod_oes
dodos75819393dod_o_s
dols56943053__d_ols
donzels1735393donzels
fools86824203fo__ols
formols12299413formols
godsons966663godsons
googols935483googols
idols65514133_id_ols
indols74714203ind_ols
iodous7311503iod_ous
modals93914463mod_als
models94216363mod_els
modioli1045483modioli
modiolus1143773modiolus
mongols103310823mongols
mools76027173mo__ols
mozos165516333mo_zo_s
nodous7711333nod_ous
obols73715863_o_bols
odeons739023_odeons
odious749933_odious
odors64514283_od_ors
odyls9428653_od_yls
orzos143311253_orzo_s
osmols8137313_osmols
ouzels15408703_ouzels
ouzos143210413_ouzo_s
parols84722613p_arols
patrols93513513patrols
pedalos10329703pedalos
pedals94316033ped_als
pedros9312183pedro_s
petrols92913083petrols
phenols1238103phenols
phytols15276553phytols
pistols93213983pistols
poboys1397313po_boys
podgily1435213podgily
podites103014733podites
podiums12227633podiums
pods76540163pod___s
podsolic1344173podsolic
podzolize2042373podzolize
podzolizes2142393podzolizes
pogroms1237643pogroms
poisons9310353poisons
polios84019723polio_s
polls74627723po__lls
polos76129913po_lo_s
pols66044563p___ols
polyol1138713polyol_
pomelos11218133pomelos
pommels13235793pommels
pomos95321583po_mo_s
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
pontils9312213pontils
pontons93315553pontons
poods85124753po__ods
poofs105222793po__ofs
poohs103915713po__ohs
pool65835953po__ol_
poons75430973po__ons
poops94422413po__ops
poos65949113po__o_s
pornos85015253porno_s
porous84419483po_rous
portals94015563portals
posole8314223po_sole
posoles9314883po_soles
postals93716383postals
postops11311713postops
potboils1284633potboils
potboys1475273potboys
potfuls1236293potfuls
pothole12312173pothole
potholes13312933potholes
pothos114214693potho_s
potions93417423potions
pottos84615873potto_s
potzers184010543potzers
powwows1442853powwows
poyous112911623po_yous
pozzolan1892663pozzolan
pozzolans19131983pozzolans
pyrrols1235403pyrrols
rodeos75314503rodeo_s
sodoms989673sod_oms
sokols10399093so_kols
sotols63714473so_tols
spodosols1242313spodosols
spools85115913spo__ols
toluols735823toluols
tools55325243to__ols
vodous1038603vod_ous
wadmols1333913wadmols
wools84421463wo__ols
yodels104610073yod_els

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.440406115.9
2DLD Change Limit1340271187.18618651.1
3Display Results1181180.0303933.3
 (SQL Overall)1786911187.65623340.0
 
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.