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

218 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
podsol94685(None) 
podsols1056511podsols
podzol1835081podzol
consol82614112consol
godson857382godson
pods76540152pods__
podsolic1344172podsolic
podzols1934682podzols
poison8312222poison
polyol1138712polyol
pool65835952po__ol
posole8314222po_sole
spodosol1142222spodosol
aldol61212333ald_ol
apodal9289833apod_al
apods86316343apods__
bods76244713bods__
bolson8410683bolson
bosom95516923bo_som
boson76019733bo_son
codon86522853cod_on
cods76848103cods__
console92715983console
consols92914073consols
consul82312303consul
cool66940493co__ol
cresol8310213cresol
diol57329133__diol
dobson936593dobson
dodo66024913dod_o_
dodos75819393dod_os
dol47150653__d_ol
dorsal74613943dorsal
dorsel75315503dorsel
dossal75510303dossal
dossel74813643dossel
dossil75110903dossil
fodgel1136413fodgel
foison948933foison
fool75330593fo__ol
formol112910333formol
fossil9379353fossil
gods65438043gods__
godsons966663godsons
googol835843googol
hods87239863hods__
hosel86024813ho_sel
housel95217043housel
idol56818633_id_ol
indol63714873ind_ol
losel54419423lo_sel
midsole1037813midsole
modal85919243mod_al
model84521693mod_el
modioli1045483modioli
mods77945053mods__
modulo9256983modulo
mongol94912533mongol
mool67533863mo__ol
morsel85815893morsel
mosso74715183mosso_
nodal64717793nod_al
nodose738883nodose
nods55838223nods__
obol65220613_o_bol
odeon6411483_odeon
odor55718093_od_or
ods47546213_ods__
odyl84111463_od_yl
osmol7138573_osmol
ousel55222403_ousel
pads76742953pads__
parasol939553parasol
parol74826273p_arol
parson83817903parson
passel85117003passel
patrol83213023patrol
pausal81511963pausal
pedal86022503ped_al
pedalo93811153pedalo
pedro8313153pedro_
pedros9312183pedros
peds75835243peds__
pensil83013333pensil
person83517873person
peso66925823p_eso_
pesos77221623p_esos
petrol82714063petrol
phenol1149253phenol
phytol14366563phytol
piso66727563p_iso_
pisos76021063p_isos
pistol83313333pistol
plimsol1143343plimsol
plods85719293plods__
poboy121612223po_boy
poco86826153po_co_
pocoson1156753pocoson
pod66351483pod___
podded115012713podded
podesta1036763podesta
podgily1435213podgily
podgy125610773pod_gy
podia8415283pod_ia
podite93315353podite
podium112911913podium
podzolic2243413podzolic
poesy105014063poes_y
pogrom1138593pogrom
pois66539043pois__
poise75127893pois_e
poised94918473poised
poiser84217243poiser
poises84226543poises
poisha1135723poisha
poisons9310353poisons
pol56449383p___ol
polio75722553polio_
polios84019723polios
poll66332133po__ll
polo66236633po_lo_
polos76129913po_los
pols66044563pols__
polyols1238493polyols
pomelo10238663pomelo
pommel12277453pommel
pomo85828453po_mo_
pomos95321583po_mos
pompom1436493pompom
pompon1238943pompon
poms87037743poms__
ponds85323403ponds__
pons65850603pons__
pontil8315463pontil
ponton83217643ponton
poo57757113po__o_
pood75934323po__od
poods85124753poods__
poof95541663po__of
pooh96027383po__oh
pools74427703po__ols
poon67341263po__on
poop86532813po__op
poor65630223po__or
poos65949113po__os
pops86340953pops__
popsie103013053popsie
popsy125713403pops_y
porno75120653porno_
pornos85015253pornos
porose84818743porose
portal84218463portal
pose66441733po_s_e
posed85828413po_sed
poser75128773po_ser
poses74642763po_ses
posh95427323po_s_h
poshly1437723po_shly
posit75833333po_sit
posoles9314883po_soles
posse74722273po_sse
posses85128803posses
posset84923253posset
possum1057953possum
post67953363po_s_t
postal84317533postal
postop10511943postop
posts75228783po_sts
posy96028423po_s_y
potboil1195463potboil
potboy1397813potboy
potful1138083potful
pothole12312173pothole
pothos114214693pothos
potion84519573potion
pots66452363pots__
potshot1249733potshot
potsie83916033potsie
potsy105815613pots_y
potto75320943potto_
pottos84615873pottos
pows95537663pows__
powwow1342833powwow
poyou102611523po_you
pozole1758913po_zole
presold1059603presold
prison8514023prison
prods85523553prods__
proso77222413proso_
prosos85718553prosos
puds75630513puds__
pyrrol1136273pyrrol
rodeo65921093rodeo_
rodeos75314503rodeos
rods56442063rods__
sodom8814913sod_om
sods54940213sods__
sokol94612293so_kol
sol37256623___sol
sotol54917653so_tol
spodosols1242313spodosols
sponsal946343sponsal
sponson935383sponson
sponsor934973sponsor
spool75219043spo__ol
spousal965533spousal
tods56141843tods__
toluol636903toluol
tonsil6311873tonsil
tool46735683to__ol
topsoil977143topsoil
torso56922143torso_
torsos64815733torsos
vodou939343vod_ou
wadmol1234053wadmol
wool76427373wo__ol
yodel94714083yod_el
yods86531183yods__

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162185.59320153.0
3Display Results2182180.0633460.3
 (SQL Overall)1786912186.03229623.8
 
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.