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

311 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
elapsing114671(None) 
lapsing103511161_lapsing
relapsing1236841relapsing
clapping153810602clapping
clasping133310262clasping
classing113211792classing
easing74926462e_a_sing
eclipsing1443742eclipsing
elaphine1346112elaphine
elapine9310672elap_ine
elating83423082ela_ting
eloping103512832elop_ing
erasing8317962era_sing
flapping16298152flapping
glassing10329972glassing
lapping124117022_lapping
lapwing13308262_lapwing
lasing74727982_la_sing
leaping103215992leap_ing
leasing83920162lea_sing
slapping133510832slapping
abasing10610673aba_sing
adapting1236643adapting
alarming1138583alarming
aliasing9310073aliasing
amassing1138003amassing
aping87327233__ap_ing
basing95427663_ba_sing
becapping1834243becapping
beclasping17134073beclasping
beladying1634763beladying
belauding1335463belauding
belaying143110603bela_ying
beleaping1436743beleap_ing
biasing103512453bia_sing
biassing11307263biassing
blabbing12266723blabbing
blacking174213603blacking
blading113615363bla_ding
blagging13319163blagging
blaming123515693bla_ming
blanking154411933blanking
blaring104317113bla_ring
blasting114013433blasting
blatting114111653blatting
blawing134012753bla_wing
blazing193612393bla_zing
blessing1137593blessing
blipping15306803blipping
blissing1136873blissing
blousing1138793blousing
braising113014563braising
brassing112612303brassing
capping143819673_capping
casing94829103_ca_sing
causing103614413_causing
ceasing104118263cea_sing
chapping183710723chapping
chasing133715893cha_sing
clacking173313493clacking
cladding1337143cladding
clagging13328873clagging
claiming13279303claiming
clamming15329373clamming
clamping154011153clamping
clanging124012123clanging
clanking154313063clanking
clashing143812193clashing
clawing133812673cla_wing
claying133614303cla_ying
cleansing1235073cleansing
cleping123310423clep_ing
clipping15349153clipping
clopping153511083clopping
closing103114843cl_osing
coapting133511613coapting
collapsing1543823collapsing
craping124018713crap_ing
crapping153911453crapping
dapping133714793_dapping
debasing12238063deba_sing
declassing1445123declassing
degassing1234823degassing
delating103119603dela_ting
delaying133210973dela_ying
delousing1136303delousing
draping114213353drap_ing
eagling91113603e_agling
eanling81416673e_anling
earing75235483e_a_ring
earning83418213e_arning
earring83519013e_arring
easting84924303e_asting
eating75134403e_a_ting
effusing1534263effusing
elain55324703ela__in_
elains64919853ela__ins
elapid939543elap_i_d
elapids1036503elap_ids
elapse857523elaps__e
elapsed1056103elaps_ed
elapses957663elaps_es
elastin72611843elastin_
elastins82111743elastins
elbowing1435013elbowing
electing112113783electing
elegising1145423elegising
eliding93414343el_iding
eloining9310443eloining
eluding93412113el_uding
eluting84115293el_uting
emailing113010043emailing
empaling1338363empaling
enabling1138603enabling
enacting11311363enacting
encasing11610823encasing
enclasping1544103enclasping
enlacing1148773enla_cing
enlarging1135803enlarging
erepsin937383erepsin_
erepsins1037443erepsins
erupting11218443erupting
escaping1347063escap_ing
espying1336193e_spying
evading1237283eva_ding
evulsing1234733evulsing
exacting1838523exacting
exalting1638033exalting
exampling2143553exampling
excising1837213excising
excusing1836503excusing
exposing1836673exposing
feasing113916653fea_sing
flacking184311793flacking
flagging14329223flagging
flailing12298923flailing
flaking154114493fla_king
flaming134216443fla_ming
flamming16357153flamming
flanging132710583flanging
flanking164211083flanking
flaring114116803fla_ring
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
flawing143812563fla_wing
flaying143914463fla_ying
flensing1246973flensing
flipping16307663flipping
flopping16388773flopping
flossing12247903flossing
frapping16348103frapping
gaping105618923_gap_ing
gapping134214783_gapping
gasping113714363_gasping
gassing94216333_gassing
gelating103015733gela_ting
glaceing1236533glaceing
gladding1236303gladding
glairing1047283glairing
glancing1247063glancing
glaring93714883gla_ring
glassine9329313glassine
glazing183611003gla_zing
glimpsing1542593glimpsing
glopping14307753glopping
glossing10278883glossing
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
happing153817233_happing
hasping134414903_hasping
heaping133015853heap_ing
hearsing1239383hearsing
helping133512223hel_p_ing
japing165013573_jap_ing
kelping14319193kel_p_ing
knapping17314973knapping
lacing94626233_la_cing
lacking143821543_lacking
lading84227123_la_ding
ladling92813393_ladling
lagging103316733_lagging
lairing83715343_lairing
laking115027043_la_king
lalling83519623_lalling
lambing123412413_lambing
laming94528363_la_ming
lamming123014583_lamming
lamping123116003_lamping
lancing103314123_lancing
landing92819323_landing
lapin75222923_lap_in_
lapins84520683_lap_ins
lapwings14274973_lapwings
larding92917873_larding
larking123718253_larking
lashing114422893_lashing
lassoing946383_lassoing
lasting84725243_lasting
lathing114315693_lathing
lauding93211903_lauding
laving104623573_la_ving
lawing104625283_la_wing
laying104525703_la_ying
lazing164821473_la_zing
lazying2046673_lazying
leaching143012833leaching
leading93419553lea_ding
leafing113313583lea_fing
leaguing1035343leaguing
leaking123616973lea_king
leaning83721203lea_ning
learning978553learning
leashing123310313leashing
leasings9379843lea_sings
leaving114216853lea_ving
lensing84015103_lensing
liaising937913liaising
lipping123016073_lipping
lisping103412753_lisping
loosing83515963_loosing
loping93921413_lop_ing
lopping123815223_lopping
losing74022873_l_osing
lousing83817733_lousing
lysing104710443_l_ysing
mapping143413993_mapping
massing104318023_massing
napping123514183_napping
palping124112873palp_ing
parsing103819553_parsing
passing104318423_passing
pausing103912813_pausing
phasing133211673pha_sing
placing123815283pla_cing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pla_ning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
pleasing112611593pleasing
plopping12318703plopping
praising113214563praising
prolapsing1543873prolapsing
raising83220533_raising
ralphing1435413ralphing
raping94829853_rap_ing
rapping123619103_rapping
rasing74330833_ra_sing
rasping104316253_rasping
realising10313173realising
reaping103621213reap_ing
recapping1636453recapping
reclasping15105083reclasping
relacing112516043rela_cing
relanding112110923relanding
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
releasing10411013releasing
remapping1635023remapping
repassing12249423repassing
reraising10313773reraising
retaping113012553retap_ing
sapling103217863_sapling
sapping123519313_sapping
sassing84615553_sassing
scaping123715693scap_ing
shaping133116183shap_ing
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slamming133310003slamming
slanging103413433slanging
slanting94115093slanting
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
sliping103314413slip_ing
slipping133510663slipping
sloping104114073slop_ing
slopping133811423slopping
snapping13349653snapping
soaping103616223soap_ing
stapling112813153stapling
swapping16348673swapping
synapsing1583483synapsing
taping94222393_tap_ing
tapping123317133_tapping
tawsing1138673_tawsing
teasing83918513tea_sing
traipsing1235073traipsing
trapesing1247263trapesing
trapping132911393trapping
wapping153514603_wapping
whapping19317113whapping
woopsing1435633woopsing
wrapping16297623wrapping
yapping153412613_yapping
yelping13317873yel_p_ing
zapping213211473_zapping

Search took 7 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.420425454.8
2DLD Change Limit1461623116.39022873.6
3Display Results3113110.1262468.3
 (SQL Overall)1786913116.93625762.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.