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

109 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
poleaxed185482(None) 
poleaxe1656301poleaxe_
poleaxes1767271poleaxes
pileated112711132pileated
pleaded113511262p_leaded
pleased103712072p_leased
pleated103816632p_leated
poleax1547992poleax__
polkaed1435322polka_ed
beleaped1336103beleaped
bleared104211253_bleared
bleated104015973_bleated
bollixed1834483bollixed
bolloxed1834473bolloxed
cleaned103512003_cleaned
cleared103612463_cleared
cleated103417843_cleated
cleaved134010483_cleaved
coaxed165612513co__axed
coheaded1536603coheaded
colead94114643colea__d
coleader1139183coleader
coleseed1147403coleseed
collaged12279973collaged
collared113211143collared
collated113615063collated
deleaded1148333deleaded
deleaved1346573deleaved
dogeared1145793dogeared
flexed17419093_fle_xed
foliaged1344673foliaged
foliated1249913foliated
foveated1536293foveated
galeated104111573galeated
gleamed11327933_gleamed
gleaned9349423_gleaned
hoaxed17378873ho__axed
hollaed11359853holla_ed
leaded84221543__leaded
leafed105713873__leafed
leaked114217703__leaked
leaned73422543__leaned
leaped94317773__leaped
leased74722883__leased
leaved105719023__leaved
molested11178243molested
nonleaded1145853nonleaded
oleate6318883_oleate_
oleates7417833_oleates
palaced124110773pal_aced
paleae84820293palea_e_
paleate94120003paleate_
palmated132511003palmated
palpated13249763palpated
peaced115818913p__eaced
peaked136117403p__eaked
pealed95322813p__ealed
phreaked1834493phreaked
pickaxed2443513pickaxed
pileate93815923pileate_
pillaged12298093pillaged
pillared11228093pillared
placed114318003p_l_aced
planed94420913p_l_aned
plated95225773p_l_ated
played124815033p_l_ayed
pleached16338063p_leached
plead85818463p_lea__d
pleader103511753p_leader
please84315733p_lease_
pleaser93912343p_leaser
pleases94515483p_leases
pleater93916333p_leater
pledged12358633p_ledged
plexes155313543p_le_xes
pokeweed1842943pokeweed
poleaxing1944873poleaxing
poled84934843pol___ed
polemized2346503polemized
poleward1455943poleward
policed123212233pol_iced
polished1468433polished
pollard103511143polla_rd
pollarded1344703pollarded
polled94022003pol__led
pollenated1345013pollenated
pollened1157783pollened
polluted1135433polluted
polyped1537173pol_yped
pomaded13377863po_maded
popeyed1535713pope_yed
portaged12228463portaged
portaled11239203portaled
powered132911643powe_red
poxed154817863po___xed
preaged11612333p_reaged
pulsated1136853pulsated
relaxed153312533rel_axed
released9310243released
sleaved113611133_sleaved
solaced102911063sol_aced
solated83618023sol_ated
solvated12237443solvated
spoliated1246913spoliated
telexed1536323tele_xed
tolerated1049123tolerated
unleaded10411333unleaded
unleased9310713unleased
upleaped1334333upleaped

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621097.39019778.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.87222699.6
 
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.