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

138 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
quippier213377(None) 
quipper2095821quipp_er
chippier17297672chippier
cuppier1368322cu_ppier
dippier123111392_dippier
drippier1385042drippier
equipper2143052equipp_er
grippier1355202grippier
hippier143212102_hippier
lippier112710572_lippier
nippier11319832_nippier
quipped2175162quipp_ed
quippers2184812quipp_ers
quippiest2243992quippiest
quipping2234842quipping
quippish2442632quippish
quipster1933932quipster
quirkier2134162quirkier
slippier1256542slippier
snippier1255792snippier
tippier113210542_tippier
trippier1246622trippier
whippier18265822whippier
zippier20308192_zippier
bumpier13359203bu_mpier
buppie12288733bu_ppie_
buppies133011063bu_ppies
chipper163912583chipp_er
chippie16297693chippie_
chippies17309763chippies
chirpier15276303chirpier
choppier17286643choppier
clipper133710323clipp_er
crappier14288133crappier
crimpier14287323crimpier
crippler14826713crippler
crispier12297253crispier
cupper124313863cu_pp_er
dipper114017793_dipp_er
dripper12349233dripp_er
dumpier12409653du_mpier
equipped2243073equipp_ed
equippers2242903equipp_ers
equipping2342843equipping
flappier1544303flappier
flipper14389143flipp_er
floppier1554633floppier
gappier12369843_gappier
gimpier12247943_gimpier
gipper114215303_gipp_er
gloppier1354673gloppier
gripier103210323gri_pier
gripper124410713gripp_er
guiltier934493guiltier
gulpier1046953gu_lpier
guppies123310523gu_ppies
happier143312043_happier
hipper133818023_hipp_er
hippie132811243_hippie_
hippies142813753_hippies
hoppier143110703_hoppier
humpier143110723hu_mpier
juicier1635463jui_cier
jumpier18317943ju_mpier
kipper143414213_kipp_er
lipper104219633_lipp_er
loppier11369723_loppier
lumpier113410143lu_mpier
nappier114411173_nappier
nipper103715713_nipp_er
pappier103511603_pappier
peppier10268323_peppier
pipier104913983_pi_pier
preppier1156643preppier
pulpier1148623pu_lpier
puppies103212623pu_ppies
quackier23215373quackier
quaggier1933853quaggier
quakier20239203qu_akier
qualmier1934563qualmier
quarrier1736843quarrier
quartier1737543quartier
queasier1734473queasier
queazier2642833queazier
querier16310013qu_erier
quibbler2132843quibbler
quicker2247023qui_cker
quickie2235513quickie_
quickies2336773quickies
quieter162810333qui_eter
quilter16279803qui_lter
quinsied1845043quinsied
quinsies1737623quinsies
quippu19344863quipp__u
quippus20363543quipp_us
quippy22384263quipp__y
quipsters2043593quipsters
quitter162910753qui_tter
quiver18278743qui__ver
quiverer2044463quiverer
quizzer2434393qui_zzer
ripper103518653_ripp_er
rippler113210103_rippler
ripplier1234463_ripplier
rumplier1235303rumplier
sappier113613123_sappier
shipper143514043shipp_er
sipper103920993_sipp_er
skimpier1634293skimpier
skipper15339573skipp_er
slipper113712983slipp_er
sloppier1255713sloppier
snappier1266223snappier
snipper113911333snipp_er
soppier112711583_soppier
squiffier2442843squiffier
squinnier1843033squinnier
squintier1844473squintier
squirmier2042853squirmier
squishier2143383squishier
stippler1235543stippler
supper104115433su_pp_er
suppler1148433su_ppler
supplier1246603supplier
tipper103918413_tipp_er
tippler11348343_tippler
tipsier9268893_tipsier
tripper113711923tripp_er
upper93714263_u_pp_er
whipper173611383whipp_er
wimpier14248053_wimpier
wispier12249403_wispier
yippie13277843_yippie_
yippies14279293_yippies
yuppie13297133yu_ppie_
yuppies14339263yu_ppies
zappier20458373_zappier
zipper193813123_zipp_er

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 Limit1461621387.09320606.5
3Display Results1381380.0502760.0
 (SQL Overall)1786911387.56323627.0
 
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.