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

131 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
weaner9381677(None) 
leaner64022191leaner
meaner84617841meaner
weaker134015441weaker
weaned103816151weaned
weaners104613831weaners
wearer94319411wearer
weaver123916611weaver
weiner94214131weiner
beader94623792beader
beaker125520692beaker
beaned95621472beaned
beanery1237562beanery
bearer85323912bearer
beater84729392beater
beaver114819252beaver
caner75334772_caner
cleaner93712302cleaner
deader84220472deader
deafer104114812deafer
dealer74122142dealer
deaned84620452deaned
deanery1137612deanery
dearer74822802dearer
eager65526972_eager
earner63617222_earner
eater54639842_eater
fearer94820182fearer
feater95224052feater
gleaner8379772gleaner
header104422542header
healer94221802healer
heaper114119522heaper
hearer94323652hearer
heater94828302heater
heaver124819672heaver
inaner62213542inaner
jeaned143813462jeaned
keener104012842keener
leader74824652leader
leaker104620072leaker
leaned73422542leaned
leaners73718172leaners
leaper88118942leaper
learner7319382learner
leaser65322672leaser
leaver94321512leaver
loaner64416502loaner
meager94515202meager
meander1049972meander
meaners94415242meaners
moaner84415112moaner
nearer64618892nearer
neater64424312neater
penner84616662penner
planer84122652planer
reader73628292reader
realer63528592realer
reamer84325212reamer
reaper84223142reaper
rearer64928912rearer
reaver94524732reaver
saner54334322_saner
sealer63928962sealer
seamer84223612seamer
searer65432022searer
seater64534162seater
seiner64622482seiner
swearer10349952swearer
sweater103712722sweater
tearer64822902tearer
teaser65421522teaser
teener64717502teener
tenner64117102tenner
tweener10306832tweener
vealer94016542vealer
veiner94514752veiner
wader95325362w_ader
wafer114417642w_afer
wager95925052w_ager
waker125526592w_aker
waler84229262w_aler
wander104423712w_ander
wane76344722w_ane_
waned95831782w_aned
wanes85040882w_anes
waney115120322w_aney
wanier93920682w_anier
wanker134219972w_anker
wanner94019622wanner
wanter94423052w_anter
warner93717222warner
water84733312w_ater
waver115025702w_aver
waxer154317482w_axer
weaken13349602weaken
weakener1534912weakener
wean75734352wean__
weans85326742wean_s
wear75836722wea__r
wearers104615902wearers
wearier103613292wearier
weasel93410522weasel
weather133513222weather
weave115218532weave_
weaved133913482weaved
weavers133714462weavers
weaves123616372weaves
weber10313522we_ber
wedder113612302wedder
weeder103315512weeder
weened104013732weened
weenier103210802weenier
weeper114313302weeper
weer75535092we__er
weever123811442weever
weiners103913062weiners
welder102914412welder
welter93417382welter
wennier10318602wennier
wester94222892wester
wether123315392wether
wetter93919442wetter
whaler124611972whaler
whiner124516632whiner
wiener94513542wiener
winner94219932winner
wonner95114442wonner
wreaker143610042wreaker
yeaned103813902yeaned
yearner10336872yearner

Search took 5 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.373479064.3
2DLD Change Limit825511314.11020085.4
3Display Results1311310.0462847.8
 (SQL Overall)1786911314.52939454.8
 
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.