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

170 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
podsols105651(None) 
podsol946851podsol_
podzols1934681podzols
consols92914072consols
godsons966662godsons
podsolic1344172podsolic
podzol1835082podzol_
poisons9310352poisons
polyols1238492polyols
pools74427702po__ols
posole8314222po_sole
posoles9314882po_soles
spodosols1242312spodosols
aldols7109713ald_ols
apodoses1136653apodoses
apodosis1146583apodosis
apodous1037403apod_ous
bolsons969483bolsons
bosoms104913053bo_soms
bosons85016653bo_sons
codons96119463cod_ons
consol82614113consol_
console92715983console
consoles103216153consoles
consuls92412313consuls
cools75632633co__ols
cresols939643cresols
diols65521013__diols
dobsons1036203dobsons
dodoes85716103dod_oes
dodos75819393dod_o_s
dols56943053__d_ols
dorsals84110843dorsals
dorsels84412573dorsels
dossals8379293dossals
dossels85511603dossels
dossils8669773dossils
foisons1047613foisons
fools86824203fo__ols
formols12299413formols
fossils10379013fossils
godson857383godso_n
googols935483googols
hosels94218603ho_sels
housels105312133housels
idols65514133_id_ols
indols74714203ind_ols
iodous7311503iod_ous
losels64714583lo_sels
midsole1037813midsole
midsoles1137763midsoles
modals93914453mod_als
models94216353mod_els
modioli1045483modioli
modiolus1143773modiolus
mongols103310823mongols
mools76027173mo__ols
morsels94112653morsels
nodous7711333nod_ous
obols73715863_o_bols
odeons739023_odeons
odious749933_odious
odors64514283_od_ors
odyls9428653_od_yls
osmols8137313_osmols
ousels64815273_ousels
parasols1039263parasols
parols84722613p_arols
parsons93516873parsons
passels93913023passels
patrols93513513patrols
pedalos10329703pedalos
pedals94316033ped_als
pedros9312183pedro_s
pensils92811593pensils
persons93717013persons
pesos77221623p_eso_s
petrols92913083petrols
phenols1238103phenols
phytols15276553phytols
pisos76021063p_iso_s
pistols93213983pistols
plimsols1242973plimsols
poboys1397313po_boys
pocosons1266103pocosons
podestas1146853podestas
podgily1435213podgily
podites103014733podites
podiums12227633podiums
pods76540153pod___s
podzolic2243413podzolic
poesies93217403poesies
pogroms1237643pogroms
poisers94214433poisers
poises84226543pois_es
poison8312223poiso_n
polios84019723polio_s
polls74627723po__lls
polos76129913po_lo_s
pols66044563p___ols
polyol1138713polyol_
pomelos11218133pomelos
pommels13235783pommels
pomos95321583po_mo_s
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
pontils9312213pontils
pontons93315553pontons
poods85124753po__ods
poofs105222793po__ofs
poohs103915713po__ohs
pool65835953po__ol_
poons75430973po__ons
poops94422413po__ops
poos65949113po__o_s
popsies112816463popsies
pornos85015253porno_s
porous84419483po_rous
portals94015563portals
posers84223973po_sers
poses74642763po_s_es
poshly1437723po_shly
posies84431433po_sies
posits85718713po_sits
posses85128803po_sses
possess9419123possess
possets94212773possets
possums1145753possums
postals93716373postals
postops11311713postops
posts75228783po_s_ts
potboils1284633potboils
potboys1475273potboys
potfuls1236293potfuls
pothole12312173pothole
potholes13312933potholes
pothos114214693potho_s
potions93417423potions
potshots1346283potshots
potsies93019483potsies
pottos84615873potto_s
powwows1442853powwows
poyous112911623po_yous
pozole1758913po_zole
pozoles1839063po_zoles
presold1059603presold
prisons9313223prisons
prosos85718553proso_s
psoas75012983p__soas
pyrrols1235403pyrrols
rodeos75314503rodeo_s
sodoms989673sod_oms
sokols10399093so_kols
sols45448163___sols
sotols63714473so_tols
spodosol1142223spodosol_
sponsons1045813sponsons
sponsors1045753sponsors
spools85115913spo__ols
spousals1064353spousals
toluols735823toluols
tonsils7310183tonsils
tools55325243to__ols
topsoils1095143topsoils
torsos64815733torso_s
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.1561145455.1
2DLD Change Limit1340271707.14318763.4
3Display Results1701700.0602833.3
 (SQL Overall)1786911707.35924282.0
 
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.