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

136 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
whippets1825525(None) 
whippers18329041whippers
whippet17328841whippet_
chippers173510882chippers
hippest14219752_hippest
shippens15316802shippens
shippers153012312shippers
sippets113310182_sippets
skippets16284562skippets
snippets12225622snippets
tippets11339372_tippets
trippets12357422trippets
whappers18276742whappers
whiffets2072522whiffets
whimpers18276612whimpers
whipped18379332whippe_d
whipper173611382whippe_r
whippiest19265112whippiest
whispers16266992whispers
whoppers18297532whoppers
chaplets1556883chaplets
chipped174110813chippe_d
chipper163912583chippe_r
chippies17309753chippies
chippiest18256803chippiest
chirpers15358133chirpers
choppers174110463choppers
clippers14368843clippers
dipnets10109033_dipnets
dippers123615183_dippers
drippers13327943drippers
flippers15338003flippers
flippest1535173flippest
gippers123212083_gippers
grippers13358133grippers
grippes124810373grippe_s
happens14359173_happens
heppest14228143_heppest
hipless12399923_hipless
hipness12277383_hipness
hipped144317693_hippe_d
hipper133818023_hippe_r
hippies142813743_hippies
hippiest152611613_hippiest
hippos13408433_hipp_os
hoppers143115143_hoppers
kippers153211433_kippers
lappets11329123_lappets
limpets11329783_limpets
lippens11328533_lippens
lippers113416443_lippers
moppets13307163_moppets
nippers113012623_nippers
pipets105714773_pi_pets
poppets10338853_poppets
puppets10317013_puppets
quippers2184813quippers
rippers114115033_rippers
ripplets12316733_ripplets
shipless13277693shipless
shipments16254703shipments
shipped153312103shippe_d
shippen14298863shippe_n
shipper143514043shippe_r
shippons15255663shippons
shoppers153010763shoppers
shoppes143411393shoppe_s
sippers113117753_sippers
sippet103519393_sippet_
skippers16318203skippers
skippet15288463skippet_
slippers123711233slippers
snippers12299723snippers
snippet113310433snippet_
snippety15263493snippety
tappets113610013_tappets
thickets17287083thickets
tippers113414353_tippers
tippet103917873_tippet_
triplets103510263triplets
trippers123210163trippers
trippet113714113trippet_
whapped18367573whappe_d
whapper17348273whappe_r
whets115019613wh___ets
whickers20297983whickers
whiffers2064493whiffers
whiffet1965343whiffet_
whiles124418013whi_le_s
whimper17297723whimpe_r
whimseys19322463whimseys
whiners134011573whi_ners
whines125120103whi_ne_s
whingers15358723whingers
whinges143610633whinge_s
whiniest14298753whiniest
whippier18265823whippier
whipping19328173whipping
whippings20284183whippings
whippy19385843whipp__y
whiprays1942503whiprays
whips134917083whi_p__s
whipsaws1942693whipsaws
whipt135317423whi_p_t_
whirlers14286053whirlers
whishes16309443whishe_s
whishts16425313whi_shts
whiskers18306773whiskers
whiskeys21353383whiskeys
whisper15298013whispe_r
whispery19284293whispery
whists124613813whi__sts
whitens13428733whi_tens
whites123919883whi_te_s
whitest133710113whi_test
whiteys16396153whi_teys
whities133113253whitie_s
whitiest14259883whitiest
whits115923823whi___ts
whitters14359403whitters
whittrets1542493whittrets
whizzers2233423whizzers
whizzes2134713whizze_s
whoopees16294823whoopees
whoopers16286263whoopers
whopped18358003whoppe_d
whopper17328503whoppe_r
whupped18365413whuppe_d
wickets164010943w_ickets
widgets12318453w_idgets
wiglets113411423w_iglets
willets104414323w_illets
wipers115416083w_i_pers
wipes104827083w_i_pe_s
wrappers15306933wrappers
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 Limit1461621366.86021306.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.32624391.3
 
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.