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

164 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
lubed8531989(None) 
cubed105519701cubed
lobed86022131lobed
lube64731561lube_
lubes74727991lubes
luged74019091luged
lured65427491lured
luted64826141luted
tubed85818041tubed
abed79734132_abed
bed67950622__bed
blubbed11338392blubbed
blued84520322blu_ed
blumed114313642blumed
blurbed12337612blurbed
buboed113010002buboed
bulbed114312772bulbed
bused85624492bused
clubbed14307452clubbed
clued84917682clu_ed
cube85830212cube_
cubeb115814662cubeb
cuber95222532cuber
cubes95028162cubes
cued76329562cu_ed
curbed114615872curbed
cured85932132cured
daubed104611782daubed
dubbed124113212dubbed
duded84417132duded
duked115218462duked
dumbed124012082dumbed
duped95118322duped
dured75025402dured
ebbed104111002ebbed
eluded84612772eluded
eluted74915262eluted
embed105014302embed
flubbed15306632flubbed
flued95021252flu_ed
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
fubbed144711242fubbed
fumed116118822fumed
fused94820442fused
fuzed185415252fuzed
gibed96215962gibed
globed104811762globed
glued75118362glu_ed
guyed1049892guyed
gybed125811022gybed
hued86925852hu_ed
imbed105013652imbed
jibed155114162jibed
jube136322782jube_
jubes145420742jubes
juked175714072juked
kluged12427212kluged
label75019382label
laced87132642laced
laded74232612laded
laked105731122laked
lambed115614782lambed
lamed85235292lamed
lased65132342lased
lated65240672lated
lauded83812152lauded
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
leben7314852leben
led46254552l__ed
libel74116102libel
liber74723622liber
lied55838092l_ied
liked104523812liked
limbed114513182limbed
limed85426802limed
lined64934642lined
lived95523722lived
lobbed113114612lobbed
lobe65535362lobe_
lobes75331002lobes
looed64626132looed
loped85128332loped
louped95316382louped
loured74617402loured
loused74822912loused
louted74920692louted
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lubber104214622lubber
luce65132572luce_
luces75528432luces
lucid84314572lucid
lucked135118022lucked
lude55331642lude_
ludes65728852ludes
lues45943552lu_es
luffed133810822luffed
luge55531642luge_
luger65322082luger
luges65928752luges
lugged94417052lugged
lulled74516442lulled
lumber103817772lumber
lumen75220902lumen
lumped114216962lumped
lune47140492lune_
lunes55337772lunes
lunet56835422lunet
lunged85418272lunged
lunted74517522lunted
lure45142462lure_
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lurid64618972lurid
lurked114511972lurked
lushed104218722lushed
lusted74319442lusted
lute46341012lute_
lutea54819072lutea
lutes55836662lutes
luxe115222692luxe_
luxes124921502luxes
lysed95011562lysed
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
nuked104014182nuked
numbed114111442numbed
orbed85516192orbed
outed65429062outed
plumbed14317272plumbed
plumed114412882plumed
pubes94423402pubes
puked124716222puked
puled84926522puled
robed85323732robed
rubbed114515082rubbed
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubied94312412rubied
rued55729792ru_ed
ruled65822522ruled
sabed86526812sabed
slubbed12339282slubbed
slued64220512slu_ed
subbed114116672subbed
suber74924502suber
sued56537932su_ed
tubbed114712222tubbed
tube65828662tube_
tuber75420682tuber
tubes74826452tubes
tuned64622312tuned
used55722822_used

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 Filter178691538000.186960704.3
2DLD Change Limit538001643.36016011.9
3Display Results1641640.0931763.4
 (SQL Overall)1786911643.63949104.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.