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

137 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
weaves12361637(None) 
deaves105319531deaves
eaves85231991_eaves
heaves124120301heaves
leaves94222381leaves
reaves94127571reaves
waves115633921w_aves
weave115218531weave_
weaved133913481weaved
weaver123916611weaver
weavers133714461weavers
agaves104611512agaves
aves76142602__aves
beaver114819252beaver
beavers124417322beavers
beeves114615042beeves
behaves15198522behaves
braves115524082braves
caves105639702_caves
ceases84427072ceases
claves115020062claves
cleaves124111622cleaves
craves115825392craves
deave95022332deave_
deaved114916552deaved
delves104917082delves
eases56041612_eases
eave75733582_eave_
eaved95924502_eaved
elves85118742_elves
eves76230462_e_ves
faves115331422_faves
feases95422922feases
feazes184514172feazes
graves104624002graves
greaves113311442greaves
haves116034872_haves
heave114521812heave_
heaved134717862heaved
heaven123912602heaven
heavens13439302heavens
heaver124819672heaver
heavers133717192heavers
heavies132713872heavies
helves124316062helves
inweaves1445042inweaves
keeves133711992keeves
knaves13439522knaves
laves86039152_laves
leases65428112leases
leave84723722leave_
leaved105719022leaved
leaven95013072leaven
leavens10409302leavens
leaver94321512leaver
leavers103717782leavers
loaves94813852loaves
naves87030382_naves
nerves94216192nerves
neves87021872ne_ves
oaves84925612_oaves
paves104833922_paves
peaces106324082peaces
peages94321852peages
peases85229472peases
peavey14398792peavey
peaveys15324062peaveys
peavies122213402peavies
peeves113814872peeves
pelves114514662pelves
raves85441972_raves
reales64934122reales
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reavers108320742reavers
reeves94721492reeves
reives95723042reives
repaves123513652repaves
reweaves1436602reweaves
saves85838632_saves
selves94119612selves
serves94423652serves
shaves125224932shaves
sheaves134412972sheaves
slaves95023022slaves
sleaves103813202sleaves
soaves94218672soaves
staves94525192staves
swerves1377532swerves
teases65426272teases
traves94222742traves
twelves1334302twelves
unweaves1436142unweaves
verves124617882verves
wades95634142w_ades
waes76048602w_a_es
wages95330932w_ages
waives123714182waives
wakes126633652w_akes
wales86142832w_ales
wames106432802w_ames
wanes85040882w_anes
wares88250582w_ares
wave105234732w_ave_
waved125223582w_aved
waver115025702w_aver
wavers125022472w_avers
wavey145115542w_avey
waveys15597012w_aveys
wavies125019842w_avies
waxes155825502w_axes
weaken13349602weaken
weakens14367062weakens
weaker134015442weaker
weakest1439002weakest
wealds10459102wealds
weals85428742wea_ls
weaned103816152weaned
weaner93816772weaner
weaners104613832weaners
weans85326742wea_ns
wearer94319402wearer
wearers104615902wearers
wearies103020222wearies
wears86030302wea_rs
weasel93410522weasel
weasels10468502weasels
wedges114614582wedges
wees76249122we__es
weever123811442weever
weevers13379992weevers
whales124716942whales
wharves16457132wharves
wherves16548052wherves
wives115328922w_ives
wolves124510852wolves

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511372.22037185.1
3Display Results1371370.0462978.3
 (SQL Overall)1786911372.59268939.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.