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

149 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
luging8391529(None) 
kluging13356591kluging
lubing94114031lubing
lugeing9359111lugeing
lugging104114351lugging
lunging93714211lunging
luring73820751luring
luting75221751luting
aging77026352_aging
auding83616932auding
bludging13297462bludging
blueing103710202blueing
bluing94914482blu_ing
bluming123511282bluming
blunging12328412blunging
budging124313022budging
bugging123515182bugging
bugling113615342bugling
bulging113514212bulging
bunging113616502bunging
busing96420592busing
buying124213832buying
caging105321022caging
clueing104110092clueing
cluing93913502clu_ing
cubing114213942cubing
cueing94913612cueing
cuing85420192cu_ing
curing94824782curing
deluging1137122deluging
duding93913322duding
dugong934372dugong
duking124715132duking
dunging103012622dunging
duping104113632duping
during84419402during
edging93510712edging
egging93210982egging
eluding93412112eluding
eluting84115292eluting
fluking154410512fluking
fluming133512792fluming
fluting113815092fluting
fluxing18398922fluxing
fudging133310012fudging
fugging133912912fugging
fugling124212512fugling
fuguing12337482fuguing
fuming124013292fuming
fusing104415952fusing
fuzing194110642fuzing
gaging94718402gaging
gauging10339962gauging
glueing9338712glueing
glugging10316352glugging
gluing83812052glu_ing
gouging103410702gouging
gurging102910112gurging
guying11379722guying
hugging132710632hugging
igging93212062igging
judging17337932judging
jugging172910722jugging
juking183810472juking
kludging15264512kludging
lacing94626232lacing
lading84227122lading
lagging103316732lagging
laking115027042laking
laming94528362laming
lasing74727982lasing
lauding93211902lauding
laughing1335932laughing
laving104623572laving
lawing104625282lawing
laying104525702laying
lazing164821472lazing
legging103912642legging
legong836962legong
liking114319582liking
liming94021232liming
ling57447962l__ing
lining74526802lining
living104318322living
lodging103110812lodging
logging103316802logging
login66025002login_
logins77820642logins
longing93915782longing
looing73621042looing
loping93921412loping
losing74022872losing
lounging1036752lounging
louping104313982louping
louring83916502louring
lousing83817732lousing
louting83719382louting
loving104416722loving
lowing104623272lowing
loxing143615272loxing
lucking143615832lucking
luffing143310102luffing
lulling83616802lulling
lumina84613542lumina
lumping123314642lumping
lung55732492lu__ng
lunting83817742lunting
lupin75215842lupin_
lupine84013532lupine
lupins84514462lupins
lurking123710852lurking
lushing114316112lushing
lusting83619322lusting
lutings83311052lutings
lying95717452l_ying
lysing104710442lysing
mugging122711792mugging
muling93519882muling
muring95120372muring
musing93919502musing
muting93921522muting
nudging10328692nudging
nuking113411252nuking
outing74128152outing
paging104020402paging
plugging13306892plugging
pluming123412042pluming
plunging12357672plunging
pugging122912542pugging
puking133913062puking
puling93621402puling
purging113314182purging
raging85126432raging
rouging93114702rouging
rugging102512762rugging
ruing67221052ru_ing
ruling73219552ruling
sludging11268362sludging
slugging11339422slugging
sluing74315882slu_ing
sughing12359712sughing
suing65026362su_ing
surging93115432surging
tubing93813082tubing
tugging102611232tugging
tuning74016842tuning
urging83413122urging
using66317962_using
waging114318382waging

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.1261418182.5
2DLD Change Limit825511492.43633887.9
3Display Results1491490.0463239.1
 (SQL Overall)1786911492.60868516.5
 
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.