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

364 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
ligating10221228(None) 
legating102313111legating
lighting132811831lighting
alighting1446412alighting
bighting15269452bighting
blighting1635732blighting
dighting142510842dighting
dilating102714912dilating
fighting162710082fighting
fixating1936182fixating
flighting1736102flighting
gating84826952__gating
highting16259722highting
legatine91311402legatine
levigating1545692levigating
librating1239052librating
lichting14268512lichting
lifting113313272li_fting
ligation92313092ligation
ligations102111992ligations
ligative1258802ligative
ligaturing1293062ligaturing
lightings14277722lightings
lightning14286022lightning
lilting83515382li_lting
limiting1138812limiting
linting83820982li_nting
liquating1946312liquating
listing84020592li_sting
litigating1246742litigating
locating11311502locating
luxating1645612luxating
migrating13910532migrating
negating102012832negating
nidating1039782nidating
obligating1445802obligating
pirating11314512pirating
plighting1635562plighting
righting132610852righting
sighting133110862sighting
slighting1436372slighting
abating10413973_abating
ablating11312003ablating
aerating92821003aerating
agisting1038243agisting
agitating1138863agitating
airting83616303ai_rting
aliasing9310073ali_asing
alienating1147233alienating
aligning10158533alig_ning
animating12312513animating
aviating12311023aviating
bating95132253__bating
beating104326873_beating
begazing2136633begazing
berating113220763berating
biasing103512453bi_asing
bigging122815883big_ging
biting95321823bi__ting
bitting103717293bi_tting
bleating113514503bleating
bloating113512813bloating
boating103721303_boating
bogarting1334653bogarting
borating113414503borating
brigading1445143brigading
cheating144014523cheating
citing94220183ci__ting
cleating113518143cleating
climaxing2143493climaxing
coating103525313_coating
colligating1545703colligating
crating103725203_crating
creating113921953creating
curating11314293curating
dating85326483__dating
debating123213733debating
delating103119603delating
delegating1337673delegating
delighting1644993delighting
derating103222283derating
dialing94318173di_aling
dictating1338883dictating
dieting93616833di_eting
digesting12208673digesting
digging113513703dig_ging
diluting10248983diluting
dinting93520553di_nting
disrating11714553disrating
divagating1644003divagating
doating93816863_doating
donating10311803donating
eating75134403__eating
elating83423083_elating
elevating1338203elevating
eliciting1237773eliciting
elongating1244523elongating
emigrating1467503emigrating
engaging1147373engaging
epilating12310973epilating
equating18310113equating
estating92614993estating
fagoting1336283fagoting
fating105328673__fating
fidgeting1544523fidgeting
figging133313563fig_ging
fightings17276503fightings
figuring1336283figuring
fileting1239303fileting
filiating1339253filiating
fisting113818123fi_sting
fitting113516563fi_tting
flinting123412343fli_nting
flirting12319013fli_rting
fliting113514613fli__ting
flitting123010883fli_tting
floating123111883floating
foliating1339253foli_ating
frighting1736023frighting
fumigating1744653fumigating
gaeing84617223__gaeing
gaging94718403__gaging
gaiting93716583__gaiting
gaming104622043__gaming
gaping105618923__gaping
gasting95022763__gasting
gatings95212823__gatings
gazing174717173__gazing
gelating103015733gelating
gifting123810893gi_fting
gigaton946343gigaton_
gigatons1046053gigatons
gigging93311773gig_ging
giggling10227043giggling
girting93113333gi_rting
gitting93215703gi_tting
glinting103210053gli_nting
gloating102611463gloating
grating93923183_grating
gyrating1337453gyrating
hating104929713__hating
heating114024323_heating
higgling14217163higgling
hilting113316893hi_lting
hinting113919223hi_nting
histing113720373hi_sting
hitting113017273hi_tting
ideating10311703ideating
igging93212073_ig_ging
igniting1037363_igniting
imaging1138083_imaging
imitating1238763imitating
ingoting1039863ingoting
iodating1038823iodating
irrigating1245953irrigating
isatin6412213_isatin_
isatine7311763_isatine
isatins7310773_isatins
jigging173011553jig_ging
jiggling18226363jiggling
jigsawing2141933jigsawing
jilting153211743ji_lting
kilting123213853ki_lting
kiting114117093ki__ting
kitting123214443ki_tting
knighting1844443knighting
lacing94626233l__acing
lactating1239193lactating
lading84227123l__ading
lagering102212313lagering
lagging103316733lag_ging
laking115027043l__aking
laminating1348733laminating
laming94528363l__aming
lapidating1445243lapidating
lariating10311793lariating
lasing74727983l__asing
lasting84725243l_asting
lathing114315693l__athing
latina65621143l__atina
latino64120473l__atino
laving104623573l__aving
lawing104625283l__awing
laying104525703l__aying
lazing164821473l__azing
leading93419553l_eading
leafing113313583l_eafing
leaguing1035343leaguing
leaking123616973l_eaking
leaning83721203l_eaning
leaping103215993l_eaping
leasing83920163l_easing
leaving114216853l_eaving
legation92412933legation
legations102711923legations
legging103912643leg_ging
leniting9312353leniting
letting83218533l_etting
levanting1345523levanting
levitating1446653levitating
liaising937913liaising
liang64914413li_a__ng
libation102411363libation
libations112510443libations
libeling1139873libeling
liberating1349253liberating
licking144118283li_cking
lidding103611433li_dding
ligament1149313ligament
ligan67920283liga__n_
ligand85011293liga__nd
ligans76817733liga__ns
ligate72519253ligat__e
ligated92414143ligat_ed
ligates82318383ligat_es
ligature945133ligature
lighten112811523lighten_
lightening15255053lightening
lightens122510003lightens
lightering15246113lightering
lightish1556623lightish
lightnings15263803lightnings
lignin74911193lig_nin_
lignins84010493lig_nins
ligroin848043ligroin_
ligroine945693ligroine
ligroins946823ligroins
likening13246893likening
liking114319583li__king
limacine1246003limacine
limbing123410423li_mbing
liming94021243li__ming
limning103710323li_mning
limping124614113li_mping
lingering11310513lingering
lining74526803li__ning
linking123818253li_nking
lipping123016073li_pping
lisping103412753li_sping
listings93310043li_stings
lithoing1236743lithoing
livening12248153livening
livering122012383livering
living104318323li__ving
loading94114613l_oading
loafing11319793l_oafing
loaming103613733l_oaming
loaning83614833l_oaning
loathing1247673l_oathing
lofting113311313l_ofting
logging103316803log_ging
looting83019643l_ooting
lotting82917753l_otting
louting83719383l_outing
lugeing9359113lug_eing
lugging104114353lug_ging
luging83915293lug__ing
lunting83817743l_unting
lusting83619323l_usting
luting75221753l__uting
mating94832913__mating
militating1348823militating
milting103619123mi_lting
minting103020813mi_nting
minuting1139723minuting
misacting1439083misacting
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
misting103623383mi_sting
mitigating1447433mitigating
moating104218153_moating
mutating112211753mutating
navigating1545003navigating
nictating1237573nictating
niggling11227443niggling
nighing123410063nig_hing
nitrating10312673nitrating
notating92513343notating
nutating92411953nutating
opiating11410093opiating
orating83520323_orating
oughting1335953oughting
oxidating1845053oxidating
picoting1338883picoting
pigging123614673pig_ging
piloting1139693piloting
pitting103618873pi_tting
pivoting1436183pivoting
placating1438513placating
plating103823073_plating
pleating112916053pleating
prating103424453_prating
pupating1337683pupating
rating74938703__rating
rebating112418343rebating
redating102620173redating
regaling10315363regaling
regrating111316213regrating
relating92725443relating
relegating1239483relegating
relighting1545853relighting
remating112322423remating
rifting113515003ri_fting
rigatoni944623rigatoni
rigging103016333rig_ging
rioting82716393ri_oting
rivaling1239913rivaling
riveting12139443riveting
rotating92614553rotating
ruinating1039593ruinating
salivating1447443salivating
sating74735453__sating
seating84130683_seating
sedating103014113sedating
sifting113014593si_fting
sighing123311663sig_hing
sightings14256533sightings
signaling1136563signaling
signeting1136223signeting
signing92713963sig_ning
silting83320483si_lting
sinuating1039683sinuating
siting74126623si__ting
sitting83519633si_tting
situating1038883situating
skating123613853_skating
slating83724653_slating
slitting93012583sli_tting
solating9315593solating
stating83725163_stating
sugaring1039053sugaring
sweating123213023sweating
tailgating1244913tailgating
tilting83417103ti_lting
tincting1148883tincting
tinting84620603ti_nting
titrating10310113titrating
treating92519613treating
ultimating1386803ultimating
ululating1036643ululating
ungazing1936033ungazing
updating1236593updating
upgazing2133313upgazing
uplighting1743363uplighting
uprating11311113uprating
urinating10310653urinating
vacating14310363vacating
validating1545843validating
vialing113614163vi_aling
vibrating1537483vibrating
violating1337443violating
visaing11279333visa_ing
visiting1238393visiting
vitiating1338413vitiating
weighting1744783weighting
wigging133413833wig_ging
wiggling14217293wiggling
wilting113515913wi_lting
wisting113519743wi_sting
witing103522823wi__ting
witting113417063wi_tting
zigging193210533zig_ging

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.406440125.6
2DLD Change Limit1461623646.93621073.0
3Display Results3643640.1562333.3
 (SQL Overall)1786913647.49823831.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.