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

104 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
warmaker173597(None) 
carmaker1637311carmaker
warmakers1845631warmakers
capmaker1855202capmaker
carmakers1736922carmakers
hatmaker1785352hatmaker
haymaker20104772haymaker
lawmaker1743922lawmaker
mapmaker1864372mapmaker
partaker1436872partaker
warmer113816732warm__er
wigmaker1843802wigmaker
wreaker143610042w_reaker
armer76924443_arm__er
armiger1036253_armiger
armorer9259913_armorer
arrayer10136703_arrayer
barker124822863bar__ker
barmier114313043barm_ier
barracker1744653barracker
barrater10310143barrater
bedmaker1744933bedmaker
breaker133912923_breaker
capmakers1944723capmakers
caretaker1545093caretaker
carjacker2443833carjacker
comaker153410603_comaker
croaker133010683_croaker
damager1157983da_mager
darker114718693dar__ker
diemaker1545593diemaker
earmarked1643223earmarked
farmer115017373farm__er
forsaker1545103forsaker
harmer114719553harm__er
hatmakers18105173hatmakers
haymakers21104553haymakers
icemaker1644443icemaker
kayaker1354503ka_yaker
larker104519243lar__ker
lawmakers1843893lawmakers
maker114127813___maker
mapmakers1944043mapmakers
marker124420393mar__ker
narrater838723narrater
pacemaker19104763pacemaker
papermaker2053423papermaker
parader103914863par_ader
parbake1538353parbake_
parbaked1735503parbaked
parbakes1638343parbakes
parker124121373par__ker
partake1339643partake_
partaken1445553partaken
partakers1536563partakers
partakes1449923partakes
phreaker1735053phreaker
playmaker2043623playmaker
rainmaker1544393rainmaker
raker94529793__r_aker
remaker133813173_remaker
sailmaker1543973sailmaker
streaker12229483streaker
swarmer1247803swarm__er
tarmacked1843773tarmacked
tarpaper1244603tarpaper
teamaker1445113teamaker
unmaker13279513_unmaker
wacker154920123wa__cker
waker125526593w___aker
walker133913993wa__lker
wanker134219973wa__nker
warbler123211463war_bler
warder104020273war__der
warfare1336733warfare_
warfares1436683warfares
warier93722893war__ier
warked144421213war__ked
warlike142410473warlike_
warmed124516893warm__ed
warmers124514293warm__ers
warmonger1543853warmonger
warner93717223war__ner
warpage1336403warpage_
warpages1437053warpages
warper114015583war__per
warpower1645043warpower
warranter1245203warranter
warrener1136913warrener
warsler10289893war_sler
warstler11275933warstler
wartier103413913war_tier
watchmaker2462613watchmaker
wayfarer1742923wayfarer
waylayer1743153waylayer
weaker134015443w__eaker
wigmakers1943383wigmakers
winemaker1844353winemaker
worker134715113wor__ker
wormer114514913worm__er
wormier12278763worm_ier
wreaked15369023w_reaked
wreakers15328423w_reakers
wrecker16367603w_recker

Search took 10 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.500357382.0
2DLD Change Limit1461621049.25015801.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911049.79618241.2
 
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.