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 “chowdered” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
chowdered194401(None) 
choppered1964882choppered
chowder16387812chowder__
chowderhead24111392chowderhead
chowders17387542chowder_s
cowered133214652c_ow_ered
powdered15256892_powdered
scowdered1643742scowdered
showered1537012show_ered
bordered1248933_bordered
bowered133113043_bow_ered
broidered1344933broidered
chaffered21154483chaffered
chambered19145993chambered
chamfered20165063chamfered
chaptered17176793chaptered
chartered15158393chartered
chattered15197993chattered
checkered2144683checkered
cheered133713293ch__eered
chequered2442613chequered
chippered1945003chippered
chittered15166413chittered
choired13349343cho__ired
chorded144710553chord__ed
chored125321883cho___red
chowderheads25101223chowderheads
chowdering2044163chowdering
chowed154914653chow___ed
chowsed16478613chow__sed
chuntered1536663chuntered
cindered1239793c_indered
clobbered16164103clobbered
clovered14187363clo_vered
clowder13367943clowder__
clowders14357473clowder_s
cockered17710213c_ockered
coffered1737673c_offered
cohered133514693c_o_hered
compered153414923c_ompered
coopered133310933c_oopered
coppered153410543c_oppered
cornered11311133c_ornered
coshered14610293c_oshered
cottered112511733c_ottered
covered133315293c_o_vered
cowherd1636953c_owher_d
crowded14418793crowd__ed
crowder13389863crowder__
crowders14398813crowder_s
doddered1234943_doddered
dowered122811553_dow_ered
flowered1546013flow_ered
foddered1434553_foddered
glowered1345753glow_ered
hindered1339453_hindered
hoidened1335653_hoidened
hollered1237603_hollered
homered133212713_ho_mered
hoovered15195413_hoovered
hovered143411573_ho_vered
howdied15296843_howd_ied
hoydened1644643_hoydened
lowered112711913_low_ered
moldered1237173_moldered
ordered9108533__ordered
pondered126411293_pondered
powderer14245593_powderer
powered132911643_pow_ered
reordered1145383reordered
shouldered1542233shouldered
showerer1436163show_erer
shuddered1543433shuddered
smoldered1343793smoldered
soldered1038153_soldered
thundered1444573thundered
towered112911403_tow_ered
unordered1145293unordered
wondered13239943_wondered

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 Filter1786911486410.406440125.6
2DLD Change Limit148641797.44019978.6
3Display Results79790.0302633.3
 (SQL Overall)178691797.87622688.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.