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

92 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
rehammers164450(None) 
rehammer1544651rehammer_
hammers144216062__hammers
rammers113715042r__ammers
reamers94221082re_a_mers
recamiers1345512recamiers
rehabbers1683132rehabbers
rehammered1843082rehammered
revampers1653442revampers
shammers153710842_shammers
behavers16205613beha_vers
chambers173410623_chambers
chamfers18409223_chamfers
champers173311623_champers
charmers154211333_charmers
clammers143510693_clammers
crammers14369353_crammers
creamers124111313cre_a_mers
dammers123214273__dammers
defamers14258523defa_mers
dreamers11369003dre_a_mers
emmers104013223_e__mmers
gammers123214563__gammers
hammer138120033__hammer_
hampers143616953__hampers
harmers124116593__harmers
hemmers143310843__hemmers
hummers143813063__hummers
jammers183710703__jammers
mammers104615693__mammers
metamers1249623meta_mers
rammer103519653r__ammer_
reachers133515723re_achers
readers83823773re_a_ders
realters83614043re_alters
reamer84325213re_a_mer_
reapers93520453re_a_pers
rearers74323563re_a_rers
reavers108320743re_a_vers
rebaters103413943reba_ters
recallers1137103recallers
recamier1237603recamier_
recanters112310483recanters
rechargers1644103rechargers
recharters1555423recharters
reclaimers1443593reclaimers
redeemers1244813redeemers
reformers14246403reformers
regainers10237383regainers
regalers94311133rega_lers
regathers1336353regathers
rehabber1563153rehabber_
rehammering1953363rehammering
rehardens13104673rehardens
rehashes1436953rehashe_s
rehearsers13273863rehearsers
reheaters122010273reheaters
rehemmed1634153rehemme_d
reimmerse1343013re_immerse
relapsers1164123relapsers
relaters83218153rela_ters
relaxers15298263rela_xers
remakers143811303rema_kers
remarkers15197283remarkers
remasters11310583remasters
remembers1544493remembers
renames92418053rena_me_s
renumbers1344123renumbers
repairers1135283repairers
repapers1258833repa_pers
reshapers1435493resha_pers
resumers1038083re_sumers
retailers9258773retailers
retainers92510763retainers
retakers123511133reta_kers
retarders10227573retarders
retempers1345023retempers
revamper1533533revamper_
rewarders13226453rewarders
rhymers15365543r_h_ymers
rimmers113812883r__immers
roamers93713463r_oa_mers
rummers113513653r__ummers
scammers14339773_scammers
seamers94719433se_a_mers
shammer144613143_shammer_
shammes144312833_shamme_s
shimmers15269413_shimmers
slammers123511223_slammers
spammers14378693_spammers
stammers123611523_stammers
yammers143410323__yammers

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.423422437.4
2DLD Change Limit148641927.03321134.8
3Display Results92920.0303066.7
 (SQL Overall)178691927.48623870.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.