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

279 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
aligning1015853(None) 
aliening91510891aliening
alining81917041ali_ning
maligning13145581maligning
aliasing9310072aliasing
alibiing1135322alibiing
alighting1446412alighting
assigning1144672assigning
clinging122910912clinging
coigning1237172coigning
deigning1137752deigning
eloigning1143452eloigning
feigning1335812feigning
flinging133310052flinging
lignin74911192_lignin_
lignins84010492_lignins
limning103710322_limning
lining74526802_li_ning
realigning1245932realigning
reigning1039882reigning
signing92713962_signing
slinging103312862slinging
abegging1334483abegging
abiding11510503abi_ding
aborning1188003aborning
adorning1087323adorning
ageing84213403a__geing
aging77026353a__g_ing
agisting1038243agisting
aiding84423613a_i_ding
ailing74331013a_i_ling
aiming94320843a_i_ming
airing74927503a_i_ring
airting83616303a_irting
alanin6317273al_anin_
alanine7316863al_anine
alanins7315803al_anins
alarming1138583alarming
alerting91312383alerting
algin65718763al_g_in_
algins74816433al_g_ins
aliasings1043653aliasings
alienating1147223alienating
alienism1047733alienism
alienist8411993alienist
align65016503alig__n_
aligned9128553align_ed
aligner8108313align_er
aligners9117573aligners
alignment1246373alignment
aligns75312953alig__ns
alimenting1344503alimenting
allaying12339303allaying
alleging1038473alleging
allowing12369093allowing
alloying12339143alloying
alluding1036953alluding
alluring939073alluring
allying113011663al_lying
altering91917113altering
angling92816043a_ngling
aproning11311793aproning
arginine948563arginine
argling92812733a_rgling
arguing9248733a_rguing
arising83619973ari_sing
arraigning1242783arraigning
asinine7310723asi_nine
atoning83514873a_toning
attuning935903attuning
avenging1345863avenging
aviating12311013aviating
awning105013393a__wning
bigging122815883_bigging
bilging114212683bilg_ing
binging113619383_binging
binning103615453_binning
blagging13319163blagging
blighting1635733blighting
blinding123210163blinding
blinking153510623blinking
blipping15306803blipping
blissing1136873blissing
blitzing2035903blitzing
blogging13369013blogging
blunging12328413blunging
bringing123011273bringing
brining103216473bri_ning
bylining1446013byli_ning
cabining1338643cabi_ning
calcining1447813calcining
chining133316843chi_ning
chinning14329653chinning
clagging13328873clagging
clanging124012123clanging
cleaning113112383cleaning
clicking173610983clicking
climbing15205983climbing
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
clogging13368503clogging
cloning103215473cl_oning
clowning14307253clowning
coining103920543coi_ning
cosigning1345393cosigning
cringing123311383cringing
designing1236623designing
digging113513703_digging
dinging103618613_dinging
dining84525133_di_ning
dinning93416553_dinning
dwining12269293dwi_ning
eliding93414343eli_ding
eloining9310443eloining
engining1039293engining
fatiguing1443053fatiguing
figging133313563_figging
fining104223213_fi_ning
finning113615113_finning
flagging14329223flagging
flanging132710583flanging
flicking184110043flicking
flighting1736103flighting
flinting123412343flinting
flipping16307663flipping
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
flogging14329173flogging
foining113013453foi_ning
frigging14268953frigging
fringing133010903fringing
gaining94015663gai_ning
gigging93311773_gigging
ginning93313983_ginning
girning93210693_girning
gleaning10269323gleaning
gliding103911843gli_ding
gliming113310133gli_ming
glinting103210053glinting
glitzing1934973glitzing
glugging10316353glugging
grinning1037863grinning
hinging123917123_hinging
igging93212073__igging
inning73617633__inning
jigging173011553_jigging
joining153011483joi_ning
kilning12289023_kilning
kinging133115033_kinging
kirning12319333_kirning
kluging13356593klug_ing
ladening1078823ladening
lagging103316733_lagging
lairing83715343lai_ring
latening9711493latening
laughing1335933laughing
leaning83721203_leaning
legging103912643_legging
licking144118283_licking
lidding103611433_lidding
lifting113313273_lifting
ligating102212283_ligating
lighting132811833_lighting
lightning14286023_lightning
lignan75510323_lignan_
lignans8398853_lignans
lignify1443793_lignify
lignite81310303_lignite
likening13246893_likening
liking114319583_li_king
lilting83515383_lilting
limbing123410423_limbing
liming94021243_li_ming
limping124614113_limping
linin58025523_li_nin_
linings84313073_li_nings
linins65922143_li_nins
linking123818253_linking
linting83820983_linting
lipping123016073_lipping
lisping103412753_lisping
listing84020593_listing
livening12248153_livening
living104318323_li_ving
loaning83614833_loaning
logging103316803_logging
longing93915783_longing
lugeing9359113_lugeing
lugging104114353_lugging
luging83915293_lug_ing
lunging93714213_lunging
malignant1245223malignant
malignity1543653malignity
margining1337603margining
mining94225453_mi_ning
misaligning1543643misaligning
neighing1355523neighing
nighing123410063_nighing
obliging1236103oblig_ing
opining10311743opi_ning
paining103920243pai_ning
patining11312303pati_ning
peining104619153pei_ning
pigging123614673_pigging
pinging113419553_pinging
pining93726533_pi_ning
pinning103417853_pinning
plaguing1236033plaguing
plaining113911553plaining
planing103418253pl_aning
planning113610223planning
plighting1635563plighting
plinking153611243plinking
plugging13306893plugging
plunging12357673plunging
prigging13299093prigging
raining83922693rai_ning
rationing1039783rationing
ravining12269693ravi_ning
reining84425323rei_ning
relining93218743reli_ning
resigning1139463resigning
rigging103016333_rigging
ringing93521283_ringing
rinning83216743_rinning
ruining83514883rui_ning
saining83621393sai_ning
salifying1636333salifying
seining84020773sei_ning
shining113816523shi_ning
shinning123211023shinning
sighing123311663_sighing
singing93221423_singing
sinning83918443_sinning
skinning13327893skinning
slagging113711573slagging
slanging103413433slanging
sleighing1434213sleighing
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
slighting1436373slighting
sliming102913953sli_ming
slimming13288093slimming
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slitting93012583slitting
slogging113410493slogging
slugging11339423slugging
spinning113310813spinning
splining11310773spli_ning
stinging103213453stinging
swigging14337223swigging
swinging133411113swinging
thinning12319093thinning
tinging93619463_tinging
tining74927543_ti_ning
tinning83117283_tinning
trigging11299583trigging
trining82919213tri_ning
twigging14305673twigging
twinging13278423twinging
twining113211443twi_ning
twinning12367043twinning
veining114713893vei_ning
vining104619463_vi_ning
weighing1635283weighing
whinging16247743whinging
whining143311673whi_ning
wigging133413833_wigging
winging123718713_winging
wining103625053_wi_ning
winning113516553_winning
wringing13279623wringing
zigging193210533_zigging
zinging183513943_zinging

Search took 9 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.1701051123.5
2DLD Change Limit1461622797.70618967.3
3Display Results2792790.1062632.1
 (SQL Overall)1786912797.98222386.7
 
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.