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

117 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
flippest153517(None) 
flappiest1644852flappiest
fliest94718432fli__est
flippant1544772flippant
flipped15358512flippe_d
flipper14389142flippe_r
flippers15338002flippers
floppiest1654772floppiest
hippest14219752_hippest
limpest113712312_limpest
lippiest122310612_lippiest
slippiest1346462slippiest
blindest11609093blindest
blipped14377193blippe_d
blithest1338083blithest
chippiest18256803chippiest
clipped14439833clippe_d
clipper133710323clippe_r
clippers14368843clippers
crispest12177373crispest
dippiest132511133_dippiest
drippiest1445363drippiest
fainest10417703fai_nest
faintest1139073faintest
fairest10412293fai_rest
filmiest1338553filmiest
finest94321733f_i_nest
fipples14298653f_ipples_
firmest1239273f_irmest
fittest102510803f_ittest
flakiest153210543flakiest
flamiest133111973flamiest
flapless1335343flapless
flapped15328253flappe_d
flapper14359203flappe_r
flappers15388383flappers
flattest1138713flattest
flawiest14298573flawiest
flaxiest18298183flaxiest
fleetest1136723fleetest
flies85630713fli__es_
flimsiest1434463flimsiest
flintiest1248433flintiest
flipping16307663flipping
flippy1654613flipp__y
flips105117743fli_p_s_
flirtiest1236193flirtiest
flites95122443fli_tes_
flopped15338763floppe_d
flopper14328473floppe_r
floppers15337463floppers
floppies1546813floppies_
flukiest15248063flukiest
flushest14338553flushest
flutiest112610883flutiest
flypast1583753fl_ypast
frappes14328383frappes_
frippery1832953frippery
glibbest1343683glibbest
gloppiest1444823gloppiest
gripiest11289633gripiest
grippes124810373grippes_
grippiest1435143grippiest
heppest14228143_heppest
hippiest152611613_hippiest
jimpest18297553_jimpest
lappet103817723_lappe_t
lappets11329123_lappets
liefest1038443_liefest
lievest1048343_lievest
likest104914383_li_kest
limiest93716103_limiest
limpet103518633_limpe_t
limpets11329783_limpets
liniest73321153_liniest
lipless9259553_lipless
lipped114419543_lippe_d
lippen103911403_lippe_n
lippens11328533_lippens
lipper104219633_lippe_r
lippers113416443_lippers
lithest10513913_lithest
livest95315733_li_vest
loppiest122410103_loppiest
nippiest12279973_nippiest
pipiest113114493_pipiest
plumpest14236353plumpest
quippiest2243983quippiest
ripest84317943_ri_pest
sippet103519393_sippe_t
sippets113310183_sippets
skippet15288463skippe_t
skippets16284563skippets
slickest14229253slickest
sliest66621953sli__est
slimiest10310743slimiest
slimmest1235903slimmest
slipes84921413sli_pes_
slipless10246993slipless
slipped124711743slippe_d
slipper113712983slippe_r
slippers123711233slippers
slippery15275863slippery
sloppiest1345973sloppiest
snippet113310433snippe_t
snippets12225623snippets
snippiest1345723snippiest
tippet103917873_tippe_t
tippets11339373_tippets
tippiest122310013_tippiest
trippet113714113trippe_t
trippets12357423trippets
trippiest1336583trippiest
whippet17328843whippe_t
whippets18255253whippets
whippiest19265113whippiest
zippiest21248093_zippiest

Search took 9 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.423422437.4
2DLD Change Limit1461621177.95318378.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.42221217.2
 
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.