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 “luxating” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

230 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
luxating164561(None) 
curating11314292curating
fixating1936182fixating
legating102313112legating
ligating102212282ligating
locating11311502locating
lunting83817742lu_nting
lusting83619322lu_sting
luting75221752lu__ting
luxation1538232luxation
luxations1637272luxations
mutating112211752mutating
nutating92411952nutating
pupating1337682pupating
ululating1036642ululating
abating10413973_abating
ablating11311993ablating
adulating1178713adulating
aerating92821003aerating
auditing1039033auditing
aviating12311013aviating
bating95132253__bating
beating104326873_beating
berating113220763berating
bleating113514503bleating
bloating113512813bloating
blunting11319843blu_nting
blurting11258773blu_rting
boating103721303_boating
borating113414503borating
bunting103718833bu_nting
bursting1138703bursting
busting104221793bu_sting
butting103519283bu_tting
cheating144014523cheating
cleating113518133cleating
coating103525313_coating
crating103725203_crating
creating113921953creating
cutting103817493cu_tting
dating85326483__dating
debating123213733debating
delating103119603delating
derating103222283derating
dilating102714903dilating
doating93816863_doating
donating10311803donating
ducting113713593du_cting
dueting93814393du_eting
duetting1047183duetting
dunting93418383du_nting
dusting93618993du_sting
eating75134403__eating
educating1337933educating
elating83423083_elating
elevating1338203elevating
eluting84115293elu__ting
eluviating1444893eluviating
emulating1239873emulating
equating18310113equating
estating92614993estating
exacting1838523_exacting
exalting1638033_exalting
exiting15311393_exiting
exulting1637643exulting
fating105328673__fating
floating123111883floating
fluting113815093flu__ting
fluxing18398923flux__ing
furcating1537783furcating
gating84826953__gating
gelating103015733gelating
gloating102611463gloating
glutting10247643glu_tting
grating93923183_grating
guesting1058463guesting
gusting93917163gu_sting
gutting93415923gu_tting
gyrating1337453gyrating
hating104929713__hating
heating114024323_heating
hunting114317123hu_nting
hurting113914033hu_rting
hutting113016033hu_tting
ideating10311703ideating
iodating1038823iodating
justing153615163ju_sting
jutting153313713ju_tting
lacing94626233l__acing
lactating1239183lactating
lading84227123l__ading
laking115027043l__aking
laming94528363l__aming
lariating10311783lariating
lasing74727983l__asing
lasting84725243l_asting
lathing114315693l__athing
latina65621143l__atina
latino64120473l__atino
laureating1146393laureating
laving104623573l__aving
lawing104625283l__awing
laxation1538423laxation
laxations1637623laxations
laxative1845093laxative
laying104525703l__aying
lazing164821473l__azing
leading93419553l_eading
leafing113313583l_eafing
leaking123616973l_eaking
leaning83721203l_eaning
leaping103215993l_eaping
leasing83920163l_easing
leaving114216853l_eaving
legatine91311403legatine
leniting9312353leniting
letting83218533l_etting
levanting1345523levanting
librating1239053librating
lichting14268513lichting
lifting113313273l_ifting
lighting132811833lighting
lilting83515383l_ilting
limiting1138813limiting
linting83820983l_inting
liquating1946313liquating
listing84020593l_isting
loading94114613l_oading
loafing11319793l_oafing
loaming103613733l_oaming
loaning83614833l_oaning
loathing1247673l_oathing
lofting113311313l_ofting
looting83019643l_ooting
lotting82917753l_otting
louting83719383l_outing
loxing143615273lox__ing
lubing94114043lu__bing
lucking143615833lu_cking
luffing143310103lu_ffing
lugeing9359113lu_geing
lugging104114353lu_gging
luging83915293lu__ging
lulling83616803lu_lling
lumping123314643lu_mping
lunatic938753lunati_c
lunatics1045473lunatics
lunation8311923lunation
lunations9310723lunations
lunching143110003lunching
lunging93714213lu_nging
lurching14277333lurching
luring73820753lu__ring
lurking123710853lu_rking
lushing114316113lu_shing
lustrating1147783lustrating
lustring9269723lustring
lutings83311053lu__tings
luxate1338083luxat__e
luxated1535713luxat_ed
luxates1436973luxat_es
luxuriating1952533luxuriating
mating94832913__mating
moating104218153_moating
mulcting13246983mulcting
munting103718773mu_nting
musting103221073mu_sting
muting93921523mu__ting
negating102012833negating
nidating1039783nidating
notating92513343notating
nutting83316233nu_tting
opiating11410093opiating
orating83520323_orating
oughting1335953oughting
ousting84021353ou_sting
outacting1239213outacting
outdating11810863outdating
outeating10814493outeating
outing74128153ou__ting
outrating10916403outrating
ovulating1336953ovulating
pirating11314513pirating
placating1438513placating
plating103823073_plating
pleating112916053pleating
prating103424453_prating
pulsating1236343pulsating
punting103318443pu_nting
putting103218573pu_tting
quaking2139313qu_aking
quanting1849233quanting
questing1838273questing
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043qu_oting
rating74938703__rating
rebating112418343rebating
redating102620173redating
relating92725443relating
remating112322413remating
rotating92614553rotating
ruinating1039593ruinating
rusting83821263ru_sting
rutting82718043ru_tting
sating74735453__sating
seating84130683_seating
sedating103014113sedating
skating123613853_skating
slating83724653_slating
solating9315593solating
stating83725163_stating
sublating12310983sublating
sugaring1039053sugaring
suiting83419003su_iting
sulfating1338063sulfating
summating1437943summating
sweating123213023sweating
treating92519613treating
tufting11289873tu_fting
tutting83515913tu_tting
unaging9510933_unaging
uniting8315823_uniting
updating1236593updating
uprating11311113uprating
vacating14310353vacating
valuating1338643valu_ating

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622307.28020077.2
3Display Results2302300.0962395.8
 (SQL Overall)1786912307.79922912.0
 
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.