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

113 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
rehammer154465(None) 
rehammers1644501rehammers
hammer138120032__hammer
rammer103519652r__ammer
reamer84325212re_a_mer
recamier1237602recamier
rehabber1563152rehabber
rehammered1843082rehammered
rehemmed1634152rehemmed
revamper1533532revamper
shammer144613142_shammer
beamier113411943be_amier
behaver15206723beha_ver
chamber164011063_chamber
chamfer17399863_chamfer
champer163813413_champer
charmer144913663_charmer
clammer134211793_clammer
crammer134010963_crammer
creamer113714093cre_a_mer
creamier12319063cre_amier
dammer114317933__dammer
defamer132710323defa_mer
dreamer104110843dre_a_mer
dreamier11287293dre_amier
emmer94314463_e__mmer
gammer1112318333__gammer
hammed144116973__hammed
hammers144216063__hammers
hammier143510653__hammier
hamper134518653__hamper
harmer114719553__harmer
hemmer134112643__hemmer
hummer133615273__hummer
jammer174014133__jammer
mammer94218863__mammer
metamer1139613meta_mer
rammed113117303r__ammed
rammers113715043r__ammers
rammier112811023r__ammier
reacher123718293re_acher
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realter73716313re_alter
reamed94326123re_a_med
reamers94221083re_a_mers
reaper84223143re_a_per
rearer64928913re_a_rer
rearmed103912823re_armed
reaver94524733re_a_ver
rebater93517913reba_ter
recaller1039323recaller
recamiers1345513recamiers
recanter101913153recanter
recharger1565483recharger
recharter1466893recharter
reclaimer1344463reclaimer
redeemer1145323redeemer
reformer13217953reformer
regainer9249353regainer
regaler83814623rega_ler
regather1236733regather
rehabbed1663713rehabbed
rehabbers1683133rehabbers
rehammering1953363rehammering
rehanged1357833rehanged
reharden1276303reharden
rehashed1536063rehashed
rehashes1436953rehashes
rehearser12265023rehearser
reheater113413033reheater
relapser1035273relapser
relater73723143rela_ter
relaxer143410223rela_xer
remaker133813173rema_ker
remarker14178493remarker
remaster10311473remaster
remember1434623remember
rename82718813rena_me_
renamed103114523rena_med
renames92418053rena_mes
renumber1244243renumber
repairer1036783repairer
repaper11310023repa_per
reshaper1336913resha_per
resumer9410113re_sumer
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retarder9229433retarder
retemper1235183retemper
revamped1634143revamped
revampers1653443revampers
rewarder12208233rewarder
rewarmed14257433rewarmed
rheumier1342513rheumier
rhymer14387083r_h_ymer
rimmer103516033r__immer
roamer84715163r_oa_mer
rummer104715483r__ummer
scammer133611973_scammer
seamer84223613se_a_mer
seamier93114633se_amier
shammed153911423_shammed
shammers153710843_shammers
shammes144312833_shammes
shimmer143310873_shimmer
slammer113913033_slammer
spammer133410433_spammer
stammer116013343_stammer
whammed18345133_whammed
yammer133713183__yammer

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.403443402.0
2DLD Change Limit1461621137.25020160.3
3Display Results1131130.0502260.0
 (SQL Overall)1786911137.70323197.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.