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

61 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
capmaker185520(None) 
capmakers1944721capmakers
carmaker1637311carmaker
mapmaker1864371mapmaker
carmakers1736922carmakers
comaker153410602c_omaker
hatmaker1785352hatmaker
haymaker20104772haymaker
lawmaker1743922lawmaker
mapmakers1944042mapmakers
warmaker1735972warmaker
bedmaker1744933bedmaker
cadaver1335793ca_daver
calker124917083ca__lker
calmer105216933calm__er
camases114216343ca_mases
camber124418483ca_m_ber
camper124722213ca_m_per
campier133313273ca_mpier
canker124422523ca__nker
canvaser13276563canvaser
capabler1435353capabler
caper94831623cap___er
caperer113013403cap_erer
capiases1239253capiases
caponier1237883caponier
capper124421983cap__per
capsomer1445773capsomer
capturer1246093capturer
caretaker1545093caretaker
carjacker2443833carjacker
catnaper1294933catnaper
caulker13456893ca_ulker
comake144413423c_omake_
comakers16339173c_omakers
comakes154413643c_omakes
comparer143611363comparer
croaker133010683c_roaker
cupcake1743953cupcake_
cupcakes1843713cupcakes
damager1157983da_mager
diemaker1545593diemaker
hatmakers18105173hatmakers
haymakers21104553haymakers
icemaker1644443icemaker
kayaker1354503ka_yaker
lawmakers1843893lawmakers
maker114127813___maker
pacemaker19104763pacemaker
papermaker2053423papermaker
partaker1436873partaker
playmaker2043623playmaker
rainmaker1544393rainmaker
rampager1344453rampager
remaker133813173_remaker
sailmaker1543973sailmaker
speaker133311213_speaker
teamaker1445113teamaker
unmaker13279513_unmaker
warmakers1845633warmakers
wigmaker1843803wigmaker

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.423422437.4
2DLD Change Limit146162617.18620339.8
3Display Results61610.0331848.5
 (SQL Overall)178691617.64223382.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.