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

225 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
jalopy1832586(None) 
jalop144212601jalop_
jaloppy21302481jaloppy
jalops15329591jalops
atopy106813392_atopy
calory11312842calory
canopy1337722canopy
galop84716222galop_
galops94712622galops
jalap143612472jalap_
jalaps15299182jalaps
adopt81219743_adopt
agony96415653_agony
ahoy101919183_aho_y
alary86123443_alary
aleph10311393_aleph
alkoxy2033343_alkoxy
alky115920343_al_ky
allay85620393_allay
alley85721673_alley
alloy85519973_alloy
ally76935643_al_ly
aloe45540193_alo_e
aloes54933673_aloes
aloft8423433_aloft
aloha8513613_aloha
aloin55227423_aloin
alone55732963_alone
along65419493_along
aloof83521573_aloof
aloud65018073_aloud
alow75328593_alo_w
alp56641133_al_p_
alps65529243_al_ps
alway116113923_alway
analogy11177853analogy
anomy105113393_anomy
aslope839013aslope
atomy107415193_atomy
atony87218853_atony
atop66124753_atop_
balcony1435853balcony
baldly12479833baldly
baldy115518933bal_dy
balky145418243bal_ky
ballsy11508873ballsy
bally105530103bal_ly
balmy125217473bal_my
baloney1237483baloney
barony115915303barony
blowy134315323_blowy
caliph13311403caliph
calmly1337613calmly
calo64936443calo__
calos74431903calo_s
campy145116183ca_mpy
clop86929893_clop_
clops95924853_clops
cloy96623833_clo_y
colony115417273colony
copy116229803__copy
dally95324743dal_ly
dopy106224153__dopy
droopy12458243droopy
elope75219343_elope
eulogy1035633eulogy
felony123710323felony
flappy1654483flappy
flop96925453_flop_
floppy1654873_floppy
flops105920143_flops
galaxy17476313galaxy
galley104215453galley
gallop93311383gallop_
gallops103211653gallops
gally95026173gal_ly
galoot72719163galoot
galoped11138073galoped
galore73514853galore
galosh1038563galosh
gappy136212033ga_ppy
gapy106320913ga__py
glop76724633_glop_
gloppy1454723_gloppy
glops85619553_glops
glory96413293_glory
goopy115816623_goopy
gulpy114612763gul_py
halo76437323halo__
haloed104717603haloed
haloes94623863haloes
haloid104317763haloid
halon86124863halo_n
halons95720713halons
halos85230253halo_s
happy155813533ha_ppy
harpy136418213ha_rpy
jabot14321513jabo_t
jabots1538883jabots
jacky215412343ja_cky
jaggy175913143ja_ggy
jailor13418573jailo_r
jailors14328753jailors
jalapic1844543jalapic
jalapin1645923jalapin
jalopies1786673jalopies
jammy194810193ja_mmy
jangly174310603jangly
janty156816963ja_nty
jape134923423ja__pe
japery18439143japery
jargony1834493jargony
jarvey19135403jarvey
jato115822683jato__
jatos125116823jato_s
jaunty16388513jaunty
jaup135316423ja_up_
jaups144810533ja_ups
jay136242673ja___y
jazzy23396363ja_zzy
jealous1438093jealous
jealousy1842223jealousy
jelly154218253jel_ly
jimpy195210823j_impy
joey145719333j__oey
joky186215313j__oky
jolly154517513jol_ly
jolty155713033jol_ty
joy137036363j__o_y
julep14310533julep_
juleps1535623juleps
jumpy195712813j_umpy
kaliph1537873kaliph
kalong1177703kalong
kalpa114512193kal_pa
kelpy145110683kel_py
logy87025783__logy
lollopy12234773lollopy
loopy105316643_loopy
lop58255313__lop_
lope65941923__lope
loppy125911663__loppy
lops66043353__lops
lory75931713__lory
malady1237863malady
malmy124816343mal_my
maloti8313213maloti
malty106721703mal_ty
melody1237203melody
mopy115721973__mopy
myopy15457353_myopy
nappy126312333na_ppy
ology94113113_ology
oology103210253oology
orlop7410903orlop_
orlops847303orlops
palapa10310673palapa
palely11311933palely
pally105727123pal_ly
palmy126016733pal_my
palp85828573pal_p_
palpi95414553pal_pi
palps94719563pal_ps
palsy105417463pal_sy
paltry114910403paltry
paly95835533pal__y
panoply1434713panoply
pappy114713803pa_ppy
parody12410093parody
plop86625743_plop_
plops95920333_plops
ploy96123603_plo_y
pulpy124612363pul_py
rally84725903ral_ly
ralph1078743ral_ph
raspy106511703ra_spy
recopy1339043recopy
ropy96323413__ropy
salary9515213salary
salep77022953salep_
saleps85014903saleps
salify12311373salify
sallowy13369343sallowy
sally85129713sal_ly
salol55222143salo_l
salols64017873salols
salon55228553salo_n
salons63823693salons
saloon64418023saloon
saloop84212583saloop
saloops93510133saloops
salp64534093sal_p_
salpa75018353sal_pa
salps74423243sal_ps
salty85524383sal_ty
sappy125413473sa_ppy
savory124310563savory
savoy114713883savo_y
saxony1636233saxony
slop66533873_slop_
slope75823563_slope
sloppy1395303_sloppy
slops75026013_slops
snoopy11449473snoopy
swoopy14487283swoopy
talcky15294723talcky
talky126215683tal_ky
tallowy13347633tallowy
tally84526863tal_ly
talon55824113talo_n
talons64019443talons
valley124311603valley
valor83614893valo_r
valors93413773valors
valour93010373valour
vampy15539403va_mpy
vapory14398763vapory
wallop113310293wallop_
wallops123410413wallops
wally114625093wal_ly
waly105830903wal__y
waspy135410993wa_spy
wicopy1634033wicopy
zappy21548943za_ppy
zloty17399793_zloty

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 Filter1786911127160.423422437.4
2DLD Change Limit1127162255.53020382.6
3Display Results2252250.0633571.4
 (SQL Overall)1786912256.01629702.6
 
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.