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

122 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
revamper153353(None) 
revamped1634141revamped
revampers1653441revampers
reamer84325212re_am_er
reaper84223142re_a_per
recamier1237602recamier
rehammer1544652rehammer
repaper11310022repa_per
retemper1235182retemper
revamp1336012revamp__
revamps1433992revamp_s
vamper134212652__vamper
beamier113411943be_amier
camper124722213__camper
champer163813413_champer
clamper134012993_clamper
creamer113714093cre_am_er
creamier12319063cre_amier
damper114117753__damper
decamped1634963decamped
defamer132710323defam_er
dreamer104110843dre_am_er
dreamier11287293dre_amier
evader1036813_eva_der
hamper134518653__hamper
heaper114119523he_a_per
leaper88118943le_a_per
levanter1145303levanter
metamer1139613metam_er
pamper124316663__pamper
prevailer1445153prevailer
rammer103519653r__ammer
ramped114617903r__amped
raper74932753r__a_per
rapper104621573r__apper
rasper83917333r__asper
ravager1136563rava_ger
reacher123718293re_acher
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realter73716313re_alter
reamed94326123re_am_ed
reamers94221083re_am_ers
reaped94122453re_a_ped
reapers93520453re_a_pers
reappear1242623re_appear
rearer64928913re_a_rer
reaver94524733re_a_ver
rebater93517913reba_ter
recaller1039323recaller
recamiers1345513recamiers
recanter101913153recanter
recapped1535943recapped
recarpet12310603recarpet
regainer9249353regainer
regaler83814623rega_ler
regather1236733regather
rehabber1563153rehabber
rehammers1644503rehammers
relapser1035273relapser
relater73723143rela_ter
relaxer143410223rela_xer
remaker133813173rema_ker
remapped1534913remapped
remarker14178493remarker
remaster10311473remaster
remember1434623remember
rename82718813renam_e_
renamed103114523renam_ed
renames92418053renam_es
renumber1244243renumber
repairer1036783repairer
repapers1258833repa_pers
repumped1534383repumped
resample1244673resample
resampled1454113resampled
resamples1344713resamples
reshaper1336913reshaper
restamped1444433restamped
resumer9410113resum_er
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retape83917683reta_pe_
retaped103814283reta_ped
retapes93917423reta_pes
retarder9229433retarder
retempers1345023retempers
revalue1038153revalue_
revalued1237023revalued
revalues1137883revalues
revamping1734633revamping
revealer113110073revealer
reveler104116343rev_eler
reveller112912183reveller
revenger1237303revenger
revenuer1136893revenuer
reverer103815833rev_erer
reverser113010483reverser
reverter114812873reverter
reviewer1434133reviewer
reviler104314973rev_iler
reviser104114663rev_iser
reviver134411373rev_iver
revoker14419193rev_oker
revolter11279363revolter
revolver14287713revolver
rewarder12208233rewarder
roamer84715163r_oam_er
romper104213683r__omper
scamper134613163_scamper
seamer84223613se_am_er
seamier93114633se_amier
stamper113714403_stamper
swamper14349313_swamper
tamper104618513__tamper
temper103914093te__mper
tramper113812163_tramper
vamped144211013__vamped
vampers143111623__vampers
vampier14308233__vampier

Search took 9 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.440406115.9
2DLD Change Limit1461621227.54619369.5
3Display Results1221220.0462652.2
 (SQL Overall)1786911228.03222247.4
 
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.