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

185 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
slippery1527586(None) 
slipper113712981slipper_
slippers123711231slippers
clipper133710322clipper_
clippers14368842clippers
flipper14389142flipper_
flippers15338002flippers
frippery1832952frippery
lipper104219632_lipper_
lippers113416442_lippers
shipper143514042shipper_
shippers153012312shippers
sipper103920992s_ipper_
sippers113117752s_ippers
skipper15339572skipper_
skippers16318202skippers
slapper113512472slapper_
slappers123710952slappers
slipped124711742slippe_d
slippered1434822slippered
slippier1256542slippier_
slippily1544192slippily
slippy1375842slipp__y
slithery14356702slithery
snipper113911332snipper_
snippers12299722snippers
snippety15263492snippety
blipped14377193blippe_d
blistery13418713blistery
chipper163912583chipper_
chippers173510883chippers
clapper134011863clapper_
clappers143310833clappers
clipped14439833clippe_d
coppery16409393_coppery
dipper114017793_dipper_
dippers123615183_dippers
dripper12349233dripper_
drippers13327943drippers
flapper14359203flapper_
flappers15388383flappers
flickery20365103flickery
flipped15358513flippe_d
flippest1535183flippest
flippy1654613flipp__y
flopper14328473flopper_
floppers15337463floppers
foppery17385623_foppery
gipper114215303_gipper_
gippers123212083_gippers
glittery12375613glittery
gripper124410713gripper_
grippers13358133grippers
hipper133818023_hipper_
kipper143414213_kipper_
kippers153211433_kippers
lapper104319953_lapper_
lappers113717463_lappers
limper104117853_limper_
limpers113815223_limpers
lipped114419543_lippe_d
lippen103911403_lippe_n
lippens11328533_lippens
lippered13287953_lippered
lippier112710573_lippier_
lippy124511903_lipp__y
lisper84114433_lisper_
lispers94514323_lispers
littery103710493_littery
livery124910903_li_very
lopper103717203_lopper_
loppers113014103_loppers
nipper103715713_nipper_
nippers113012623_nippers
peppery13286253_peppery
quipper2095823quipper_
quippers2184813quippers
ripper103518653_ripper_
rippers114115033_rippers
sapper103822353s_apper_
sappers113518903s_appers
scupper1367423scupper_
scuppers1446543scuppers
shimmery18265253shimmery
shinnery14305683shinnery
shipped153312103shippe_d
shippen14298863shippe_n
shippens15316803shippens
shivery16317023shi_very
shopper143312633shopper_
shoppers153010763shoppers
silvery13328093s_ilvery
simper103616293s_imper_
simpers113014123s_impers
sipped113720633s_ippe_d
sippet103519393s_ippe_t
sippets113310183s_ippets
skipped16358413skippe_d
skippered1843433skippered
skippet15288463skippe_t
skippets16284563skippets
skittery15315103skittery
slabbery15375773slabbery
slapped123511853slappe_d
slavery13407893sl_avery
sleeper93211563sleeper_
sleepers103110113sleepers
slicer84117603sli_cer_
slicers94114923sli_cers
slicker133314533slicker_
slickers143112553slickers
slider73918363sli_der_
sliders83515223sli_ders
slier54827243sli__er_
slimier93212013slimier_
slimmer114211343slimmer_
slimmers12369633slimmers
slimpsy1463333slimp_sy
slinger83413833slinger_
slingers93712683slingers
slipe75626133sli_pe__
sliped95417063sli_pe_d
slipes84921413sli_pe_s
slipform1543573slipform
slipless10246993slipless
slipover1343833slipover_
slipovers1443463slipovers
slippage13103943slippage
slipperier1442703slipperier
slippiest1346473slippiest
slipping133510663slipping
slipware1344543slipware
slipway1543873sli_pway
slither104112983slither_
slithers114212953slithers
slitter73615873slitter_
slitters84014133slitters
sliver94116593sli_ver_
slivers104115253sli_vers
slobbery15375663slobbery
sloper84615913sl_oper_
slopers94213093sl_opers
slopped123511443sloppe_d
sloppier1255713sloppier_
sloppily1544613sloppily
sloppy1395303slopp__y
slumbery15296043slumbery
smithery16325703smithery
snapper113512073snapper_
snappers123510173snappers
snickery17295543snickery
sniper84413643sni_per_
snipers93311773sni_pers
snipped123510043snippe_d
snippet113310433snippe_t
snippets12225623snippets
snippier1255793snippier_
snippily1543573snippily
snippy1374843snipp__y
sphery14318883s__phery
spicery14499013spi_cery
spidery13308203spi_dery
spinnery13416593spinnery
splintery14264793splintery
stepper113010853stepper_
steppers12289283steppers
stippler1235543stippler_
stipplers1334453stipplers
stopper113012603stopper_
stoppers123910593stoppers
stripper1247123stripper_
strippers1355773strippers
supper104115433s_upper_
suppers113314703s_uppers
swapper14359703swapper_
swappers15358083swappers
tipper103918413_tipper_
tippers113414353_tippers
tripper113711923tripper_
trippers123210163trippers
whipper173611383whipper_
whippers18329043whippers
whispery19284293whispery
zipper193813123_zipper_
zippers203310383_zippers

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.420425454.8
2DLD Change Limit1461621857.39319770.3
3Display Results1851850.0603083.3
 (SQL Overall)1786911857.87322696.7
 
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.