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

200 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
luting7522175(None) 
eluting84115291eluting
fluting113815091fluting
louting83719381louting
lubing94114031lubing
luging83915291luging
lunting83817741lunting
luring73820751luring
lusting83619321lusting
lutings83311051lutings
muting93921521muting
outing74128151outing
acting95920982acting
anting75827022anting
auding83616932auding
autoing8314042autoing
bating95132252bating
biting95321822biting
blueing103710202blueing
bluing94914482blu_ing
bluming123511282bluming
blunting11319842blunting
blurting11258772blurting
bruting102612992bruting
bunting103718832bunting
busing96420592busing
busting104221792busting
butling103516812butling
butting103519282butting
buying124213832buying
chuting132910732chuting
citing94220182citing
clouting113011682clouting
clueing104110092clueing
cluing93913502clu_ing
coting94629252coting
cubing114213942cubing
cueing94913612cueing
cuing85420192cu_ing
curing94824782curing
cutin75022772cutin_
cutins83919982cutins
cutting103817492cutting
dating85326482dating
dauting93814762dauting
diluting10248982diluting
doting84821912doting
ducting113713592ducting
duding93913322duding
dueting93814392dueting
duking124715132duking
dunting93418382dunting
duping104113632duping
during84419402during
dusting93618992dusting
eating75134402eating
elating83423082elating
eluding93412112eluding
fating105328672fating
feting104417792feting
fliting113514612fliting
flouting122610472flouting
fluking154410512fluking
fluming133512792fluming
flutings12357372flutings
fluxing18398922fluxing
flyting14378552flyting
fuming124013292fuming
fusing104415952fusing
futzing20307902futzing
fuzing194110642fuzing
gating84826952gating
glouting10379692glouting
glueing9338712glueing
gluing83812052glu_ing
glutting10247642glutting
gusting93917162gusting
gutting93415922gutting
guying11379722guying
hating104929712hating
hunting114317122hunting
hurting113914032hurting
hutting113016032hutting
juking183810472juking
justing153615162justing
jutting153313712jutting
kiting114117092kiting
kluging13356592kluging
lacing94626232lacing
lading84227122lading
laking115027042laking
laming94528362laming
lasing74727982lasing
lasting84725242lasting
lathing114315692lathing
latina65621142latina
latino64120472latino
lauding93211902lauding
laving104623572laving
lawing104625282lawing
laying104525702laying
lazing164821472lazing
letting83218532letting
lifting113313272lifting
liking114319582liking
lilting83515382lilting
liming94021232liming
ling57447962l__ing
lining74526802lining
linting83820982linting
listing84020592listing
living104318322living
lofting113311312lofting
looing73621042looing
looting83019642looting
loping93921412loping
losing74022872losing
lotting82917752lotting
louping104313982louping
louring83916502louring
lousing83817732lousing
loving104416722loving
lowing104623272lowing
loxing143615272loxing
lucking143615832lucking
luffing143310102luffing
lugeing9359112lugeing
lugging104114352lugging
lulling83616802lulling
lumina84613542lumina
lumping123314642lumping
lung55732492lu__ng
lunging93714212lunging
lupin75215842lupin_
lupine84013532lupine
lupins84514462lupins
lurking123710852lurking
lushing114316112lushing
lustring9269722lustring
lutein6311262lutein_
luteins7310102luteins
lutist64317552lutist
luxating1645612luxating
lying95717452l_ying
lysing104710442lysing
mating94832912mating
meting94320592meting
muling93519882muling
munting103718772munting
muring95120372muring
musing93919502musing
musting103221072musting
mutine84420372mutine
mutiny113612682mutiny
noting74120152noting
nuking113411252nuking
nutting83316232nutting
opting94514402opting
ousting84021352ousting
outings84014752outings
outring84021012outring
outsing83320462outsing
plating103823072plating
pluming123412042pluming
pouting103519942pouting
puking133913062puking
puling93621402puling
punting103318442punting
putting103218572putting
putzing19359122putzing
quoting17310042quoting
rating74938702rating
routing83821092routing
ruing67221052ru_ing
ruling73219552ruling
rusting83821262rusting
rutin55421342rutin_
rutins63818392rutins
rutting82718042rutting
saluting9310552saluting
sating74735452sating
shuting113212042shuting
siting74126622siting
slating83724652slating
sluing74315882slu_ing
sting65330242_sting
suing65026362su_ing
suiting83419002suiting
tauting83316382tauting
ting56139892__ting
toting74123792toting
touting84118452touting
tubing93813082tubing
tufting11289872tufting
tuning74016842tuning
tutting83515912tutting
using66317962_using
voting103916032voting
witing103522822witing
wyting13277242wyting

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 Filter178691825510.1731032896.0
2DLD Change Limit825512003.32624819.9
3Display Results2002000.0633174.6
 (SQL Overall)1786912003.56250165.9
 
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.