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 “reavers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
reavers10832074(None) 
beavers124417321beavers
heavers133717191heavers
leavers103717781leavers
preavers13910261preavers
ravers94628181r_avers
readers83823771readers
reamers94221081reamers
reapers93520451reapers
rearers74323561rearers
reaver94524731reaver_
reaves94127571reave_s
reivers105117081reivers
revers94529631re_vers
weavers133714461weavers
avers85127312__avers
beaders104120182beaders
beakers134216872beakers
bearers94619592bearers
beaters94925042beaters
beaver114819252beaver_
behavers16205612behavers
bereavers1446122bereavers
bravers124715522bravers
breakers143810972breakers
cavers115026842_cavers
clavers124314902clavers
cleavers13398872cleavers
cravers124416562cravers
creamers124111312creamers
creasers103612842creasers
dealers84118612dealers
deaves105319532deave_s
delvers113411992delvers
dreamers11369002dreamers
eagers74523682_eagers
eaters65535952_eaters
eaves85231992_eave_s
elvers93814982_elvers
erasers74413942erasers
fearers104815272fearers
fevers125414892fe_vers
gravers114515272gravers
greasers93410252greasers
greaves113311442greave_s
havers124721482_havers
headers113819392headers
healers104319462healers
heapers123616672heapers
hearers104319782hearers
heaters104225222heaters
heavens13439302heavens
heaver124819672heaver_
heaves124120302heave_s
lavers94526362_lavers
leaders83819602leaders
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leasers74717842leasers
leavens10409302leavens
leaver94321512leaver_
leaves94222382leave_s
levers94621322le_vers
meaners94415242meaners
pavers115021822_pavers
peaveys15324062peaveys
preaver121011612preaver_
quavers19309012quavers
racers84725432r_acers
rakers104123572r_akers
rapers84327182r_apers
rasers64526782r_asers
raters63936582r_aters
ravels94717072r_avels
ravens93916882r_avens
raver85631492r_aver_
raves85441972r_ave_s
razers154919612r_azers
reachers133515722reachers
reader73628292reader_
realer63528592realer_
reales64934122reale_s
realters83614042realters
reamer84325212reamer_
reaper84223142reaper_
rearer64928912rearer_
rears54739652rea__rs
reave84528022reave__
reaved104523922reave_d
reavows1335272reavows
rebaters103413942rebaters
recovers133511122recovers
redders93615342redders
reefers103312592reefers
reekers113613142reekers
reelers73520272reelers
reeves94721492reeve_s
refers93921082re_fers
regalers94311132regalers
reiver95318292reiver_
reives95723042reive_s
relaters83218152relaters
relaxers15298262relaxers
reliers75519212reliers
remakers143811302remakers
removers13449222removers
renders83821672renders
renters74224812renters
repapers1258832repapers
repaves123513652repave_s
resters74130402resters
retakers123511132retakers
revels94220572re_vels
reverb113912572re_verb
reverbs12368862re_verbs
revere94621252re_vere
reveres103621342re_veres
reverse103913742re_verse
reverso10367692re_verso
revert93529112re_vert
reverts104715042re_verts
revery124014212re_very
revets94022172re_vets
revivers14389632revivers
rievers104311452rievers
rivers94626542r_ivers
roamers93713462roamers
roarers73812742roarers
rovers95423522r_overs
savers93825922_savers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
servers103214832servers
severs94121122se_vers
shavers134115092shavers
slavers103716502slavers
tearers75218232tearers
teasers75317242teasers
treaders93311842treaders
treaters83615842treaters
vealers103214292vealers
wavers125022472_wavers
weaners104613832weaners
wearers104615902wearers
weaver123916612weaver_
weaves123616372weave_s
weevers13379992weevers
wreakers15328422wreakers

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711503.51330649.3
3Display Results1501500.0463260.9
 (SQL Overall)1786911503.93545410.7
 
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.