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

144 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
flimsier134413(None) 
flimsies1335781flimsies
slimsier1085211slimsier
clumsier1234732clumsier
filmier1237502film_ier
flamier123112142flam_ier
flimsiest1434462flimsiest
flimsily1643282flimsily
flintier1136392flintier
flirtier1144892flirtier
flossier11326972flossier
limbier11349112_limbier
limier83518722_lim_ier
limpsier1234432_limpsier
slimier93212012slim_ier
slimpsier1343022slimpsier
bitsier9379073_bitsier
blister94415313bli_ster
blousier1055663blousier
blowsier1335063blowsier
bluesier1034943bluesier
clammier1435843clammier
classier10359083classier
cliffier1633913cliffier
climber13449133clim_ber
clingier1155853clingier
cliquier1944223cliquier
clumpier1435583clumpier
crimpier14287323crimpier
ditsier83010293_ditsier
elmier839813el_m_ier
feistier1136193feistier
fibster12146533f_ibster
fierier103511193f_ierier
filister1137403filister
filmer114112403film__er
filmgoer1442013filmgoer
filmset1257513films_et
filthier1434073filthier
finnier10319953f_innier
firrier103410133f_irrier
fisher124917143f_i_sher
fishier13359853f_ishier
fizzier18326713f_izzier
flabbier1534093flabbier
flaggier13105203flaggier
flakier143910203fl_akier
flamer114919123flam__er
flappier1544293flappier
flasher133914063fl_asher
flashier1437103flashier
flawier13378733fl_awier
flaxier17337983fl_axier
fledgier1333683fledgier
fleecier1334763fleecier
flenser1036783flens_er
flesher133610923fl_esher
fleshier1435603fleshier
flichter1664963flichter
flicker163610623fli_cker
flier86023403fl___ier
flightier1644423flightier
flimsiness1543453flimsiness
flimsy14345563flims__y
flincher16256583flincher
flinder11319873fli_nder
flinger113710513fli_nger
flipper14389143fli_pper
flirter10318673fli_rter
flitter103413903fli_tter
flivver1633043fli_vver
floatier1136983floatier
flockier1745343flockier
floosie10378933floosie_
floosies113210233floosies
floppier1554633floppier
flosser10339693fl_osser
flossie10337443flossie_
flossies112810123flossies
fluffier13264333fluffier
flukier14397853fl_ukier
flusher133012273fl_usher
fluster103913063fl_uster
flutier103011553fl_utier
flytier13356503fl_ytier
foamier12339003foam_ier
folksier1533533folksier
frillier1136513frillier
fringier1236553fringier
frisker14389273fri_sker
friskier1535193friskier
frizzier19284813frizzier
frowsier1444893frowsier
frumpier1534173frumpier
fubsier12367763f_ubsier
fumier11310903f_um_ier
fussier103610673f_ussier
gimpier12247943_gimpier
glassier9289083glassier
glimmer12437713glim_mer
glimpser1342663glimpser
glintier945703glintier
glister84013343gli_ster
glitzier1833593glitzier
glossier9358203glossier
glumpier1334873glumpier
grimier103210433grim_ier
hissier103410503_hissier
klister113410643kli_ster
lambier113611643_lambier
lamster9109913_lamster
limber104316793_lim_ber
limiter92710853_limiter
limmer104314793_lim_mer
limner84112873_lim_ner
limper104117853_lim_per
lingier84113383_lingier
linier64423793_li_nier
lintier73613803_lintier
lippier112710573_lippier
lisper84114433_li_sper
lister64527253_li_ster
livier97514593_li_vier
lousier72411623_lousier
lumpier113410143_lumpier
noisier759453noi_sier
plumier113510043plum_ier
plummier1434123plummier
primsie1137543primsie_
prissier10157873prissier
rimier83916273_rim_ier
sissier73711363_sissier
skimpier1634293skimpier
slimmer114211343slim_mer
slimsiest1135883slimsiest
slinkier12206933slinkier
slippier1256533slippier
slittier837003slittier
slummier1235473slummier
swimmier15174313swimmier
tipsier9268893_tipsier
whimsied1743113whimsied
whimsies1635193whimsies
wimpier14248053_wimpier

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.1561145455.1
2DLD Change Limit1461621447.23320207.7
3Display Results1441440.0502880.0
 (SQL Overall)1786911447.43924020.8
 
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.