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

149 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
quippy2238426(None) 
quippu19344861quippu
buppy144810072bu_ppy
chippy18437612chippy
cuppy144710382cu_ppy
dippy135111542_dippy
drippy14445652drippy
flippy1654612flippy
grippy14447762grippy
guppy135211272gu_ppy
hippy155112792_hippy
lippy124511902_lippy
nippy124911112_nippy
puppy114912412pu_ppy
quinsy18386352quinsy
quip154818622qui_p_
quipped2175162quipped
quipper2095822quipper
quippus20363542quippus
quips164713372qui_ps
quipu164811642qui_pu
quipus17458002quipus
quirky22435532quirky
slippy1375842slippy
snippy1374842snippy
tippy125411792_tippy
trippy13457802trippy
whippy19385842whippy
yuppy15487912yu_ppy
zippy21518742_zippy
bumpy144715053bu_mpy
chirpy16498913chirpy
choppy18376293choppy
crappy15446803crappy
crimpy15489393crimpy
crispy13478563crispy
cuppa11398523cu_ppa
dumpy135414753du_mpy
equip16467263equi_p_
equipped2243073equipped
equipper2143053equipper
equips17387193equi_ps
equity1838103equi_ty
flappy1654483flappy
floppy1654873floppy
gappy136212033_gappy
gimpy135212233_gimpy
gipsy11579543_gipsy
gloppy1454723gloppy
gripey124111203gripey
grippe115310323grippe
gripy115115253gri_py
guilty10418233guilty
guimpe1134723guimpe
gulpy114612763gu_lpy
happy155813533_happy
hiply134113613_hiply
hippo12369063_hippo
hoppy154912353_hoppy
huipil1143773huipil
humpy155115673hu_mpy
jimpy195210823_jimpy
juicy1738283jui_cy
jumpy195712813ju_mpy
loppy125911663_loppy
lumpy126615913lu_mpy
murphy1654343murphy
nappy126312333_nappy
pappy114713803_pappy
peppy114310363_peppy
pipy115421513_pi_py
poppy114813193_poppy
preppy1235523preppy
pulpy124612363pu_lpy
purply13369053purply
quacky24376963quacky
quaggy2084683quaggy
quaky214310743qu_aky
qualmy20285803qualmy
quarry1837473quarry
quay164618353qu__ay
queasy1855173queasy
queazy2743573queazy
query174212083qu_ery
quey164616473qu__ey
quiche2057903quiche
quick204311063qui_ck
quickly2534073quickly
quicks21389303quicks
quid144922353qui__d
quids154917463qui_ds
quiet144530733qui_et
quietly1945893quietly
quiets154014373quiets
quiff201111563qui_ff
quiffs21135433quiffs
quill148413773qui_ll
quills153811853quills
quilt144125103qui_lt
quilts154112543quilts
quin135823923qui__n
quinary1936933quinary
quince173910133quince
quinic17319473quinic
quinin152811953quinin
quinoa15377653quinoa
quinol15357973quinol
quins144819853qui_ns
quint144529903qui_nt
quinta153312373quinta
quinte153414523quinte
quints154316563quints
quippers2184813quippers
quippier2133773quippier
quipping2234843quipping
quippish2442633quippish
quire144917133qui_re
quired163711953quired
quires154015753quires
quirk184011003qui_rk
quirks19419113quirks
quirt144624233qui_rt
quirts154213553quirts
quit136136513qui__t
quitch2036413quitch
quite144621463qui_te
quits144122353qui_ts
quiver18278743quiver
quivery22265463quivery
quiz224920003qui__z
ripply13348003_ripply
rumply13348573rumply
sappy125413473_sappy
skimpy17475723skimpy
sloppy1395303sloppy
snappy1366103snappy
soppy125113523_soppy
squiffy2542573squiffy
squinny19274223squinny
squinty19287063squinty
squirmy21374293squirmy
squishy2244023squishy
supply1346893supply
tipsy106010503_tipsy
triply114211023triply
upby1139063_u_pby
wimpy155911923_wimpy
wispy137210973_wispy
zappy21548943_zappy

Search took 6 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.390458182.1
2DLD Change Limit1127161494.84623259.6
3Display Results1491490.0433465.1
 (SQL Overall)1786911495.27933849.4
 
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.