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

129 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
skippets1628456(None) 
sippets113310181s_ippets
skippers16318201skippers
skippet15288461skippet_
snippets12225621snippets
kippers153211432_kippers
shippens15316802shippens
shippers153012312shippers
sippers113117752s_ippers
sippet103519392s_ippet_
skillets12226822skillets
skipped16358412skippe_d
skipper15339572skippe_r
skirrets12244012skirrets
slippers123711232slippers
snippers12299722snippers
snippet113310432snippet_
snippety15263492snippety
tippets11339372_tippets
trippets12357422trippets
whippets18255252whippets
chippers173510883chippers
clippers14368843clippers
dipnets10109033_dipnets
dippers123615183_dippers
drippers13327943drippers
flippers15338003flippers
flippest1535173flippest
gippers123212083_gippers
grippers13358133grippers
grippes124810373grippe_s
hippest14219753_hippest
kipped153114573_kippe_d
kippen14299013_kippe_n
kipper143414213_kippe_r
kismets13306883_kismets
lappets11329123_lappets
limpets11329783_limpets
lippens11328533_lippens
lippers113416443_lippers
moppets13307163_moppets
nippers113012623_nippers
pipets105714773_pi_pets
poppets10338853_poppets
puppets10317013_puppets
quippers2184813quippers
rippers114115033_rippers
ripplets12316733_ripplets
sappers113518903s_appers
scuppers1446543scuppers
septets998953s_eptets
shipless13277693shipless
shipments16254703shipments
shipped153312103shippe_d
shippen14298863shippe_n
shipper143514043shippe_r
shippons15255663shippons
shoppers153010763shoppers
shoppes143411393shoppe_s
signets83311503s_ignets
simpers113014123s_impers
sipes76036953s_i_pe_s
sipped113720633s_ippe_d
sipper103920993s_ippe_r
skeets104513253sk__eets
skidders1454823skidders
skiers104713703ski__ers
skies95026833ski__e_s
skilless12246763skilless
skillet113512153skillet_
skimmers16296463skimmers
skimped16256223skimpe_d
skimpiest1734503skimpiest
skimps14488043skimp__s
skinkers11298183skinkers
skinless12216973skinless
skinners12347293skinners
skippered1843433skippered
skipping17297603skipping
skips115616603ski_p__s
skirret11278173skirret_
skirters12337243skirters
skirts104111503ski__rts
skites104418043ski_te_s
skits94721863ski___ts
skitters12349553skitters
skivers14409703ski_vers
skives134113943ski_ve_s
slappers123710943slappers
slipes84921413sli_pe_s
slipless10246993slipless
slipouts1044893slipouts
slipped124711743slippe_d
slipper113712983slippe_r
slippery15275863slippery
slippiest1346463slippiest
snappers123510173snappers
sniglets9276813sniglets
snipers93311773sni_pers
snipes83917393sni_pe_s
snipped123510043snippe_d
snipper113911333snippe_r
snippiest1345723snippiest
spinets94714813spi_nets
steppers12289283steppers
steppes113110693steppe_s
stipels9418953sti_pels
stipes84524053sti_pe_s
stipites1039653stipites
stipplers1334453stipplers
stipples1247023stipples
stirpes95011293stirpe_s
stoppers123910593stoppers
strippers1355773strippers
suppers113314703s_uppers
swappers15358083swappers
swipes114114333swi_pe_s
swiples12339643swiple_s
swipples1534843swipples
swivets13436963swi_vets
tappets113610013_tappets
tippers113414353_tippers
tippet103917873_tippet_
triplets103510263triplets
trippers123210163trippers
trippet113714113trippet_
whippers18329043whippers
whippet17328843whippet_
zippers203310383_zippers

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 Limit1461621296.19023612.6
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.65626846.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.