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

116 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
weber1031352(None) 
webers11310941webers
weer75535091we_er
amber94523212amber
beer65635992be_er
caber95126832caber
ceder85322242ceder
cuber95222532cuber
cyber124910382cyber
debar85517862debar
deer56739022de_er
defer94619752defer
deter65028042deter
eger55923572_eger
ember95516802ember
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiber104921132fiber
giber85417702giber
hebe96424702hebe_
hebes105521672hebes
heder95623642heder
hewer115719932hewer
hexer155116682hexer
jebel145612142jebel
jeer115426462je_er
jiber145115702jiber
kebar115113532kebar
leben7314852leben
leer46239352le_er
leger65721512leger
leper74820742leper
lever85125162lever
liber74723622liber
member12258852member
merer75126232merer
meter75130322meter
never86218642never
newer85717462newer
omber95316442omber
peer66238352pe_er
peter74427592peter
rebar75420192rebar
rebec94416542rebec
rebel73421292rebel
refer84822142refer
saber75330242saber
seder64826762seder
seer45547042se_er
serer55935512serer
sever85426052sever
sewer84426222sewer
sober74822412sober
suber74924502suber
sweer84918572swe_er
taber73825822taber
tuber75420682tuber
umber94617592umber
veer76229572ve_er
vexer155513522vexer
wader95325362wader
wafer114417642wafer
wager95925052wager
waker125526592waker
waler84229262waler
water84733312water
waver115025702waver
waxer154317482waxer
weaker134015442weaker
weaner93816772weaner
wear75836722we_ar
wearer94319402wearer
weaver123916612weaver
web85735562web__
webbed1436432webbed
webbier1445422webbier
webby1537152webby
webfed1535032webfed
webs96622122web_s
webster1236092webster
wedder113612302wedder
wedel94513962wedel
wee66760812we_e_
weed85637512we_ed
weeder103315512weeder
week116428152we_ek
weel75834082we_el
ween75835462we_en
weep95131652we_ep
weeper114313302weeper
wees76249122we_es
weet75254152we_et
weever123811442weever
weiner94214132weiner
weir76019922we_ir
welder102914412welder
welter93417382welter
were76238332were_
wester94222892wester
wether123315392wether
wetter93919442wetter
wider94826352wider
wiener94513542wiener
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
wooer84316692wooer
wrier84521752wrier
wryer11489302wryer
xebec16378292xebec
zebec18419262zebec

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 Filter178691538000.330541487.9
2DLD Change Limit538001161.68631909.8
3Display Results1161160.0303866.7
 (SQL Overall)1786911162.04687336.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.