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 “fluffier” 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
fluffier1326433(None) 
fluffer12336501fluff_er
bluffer15396882bluff_er
buffier1568402_buffier
chuffier1934542chuffier
cliffier1633912cliffier
fluffed13295902fluff_ed
fluffers13335292fluff_ers
fluffiest1434092fluffiest
fluffily1652922fluffily
fluffing14275412fluffing
flukier14397852flu_kier
flutier103011552flu_tier
gruffier1544702gruffier
huffier1637492_huffier
puffier1547972_puffier
snuffier14276942snuffier
stuffier14336622stuffier
bluesier1034943bluesier
bluffed16326433bluff_ed
bluffers16405703bluff_ers
bluffing17275493bluffing
blurrier1035163blurrier
buffer144512683_buff_er
chaffier1935473chaffier
chuffer18337143chuff_er
clubbier1434833clubbier
clumpier1435583clumpier
clumsier1234733clumsier
clunkier14345793clunkier
daffier1457833_daffier
draffier1574323draffier
duffer134711663_duff_er
falsifier1544433falsifier
faultier1135283faultier
feoffer1233023feoff_er
flabbier1534093flabbier
flaggier13105203flaggier
flakier143910203fl_akier
flamier123112143fl_amier
flappier1544293flappier
flashier1437103flashier
flauntier1243063flauntier
flawier13378733fl_awier
flaxier17337983fl_axier
fledgier1333683fledgier
fleecier1334763fleecier
fleshier1435603fleshier
flier86023403fl___ier
flimsier1344133flimsier
flintier1136393flintier
flirtier1144893flirtier
floatier1136983floatier
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flouncier1442483flouncier
flubber14287713flu_bber
fluff103913613fluff___
fluffiness1542603fluffiness
fluffs11347783fluff__s
fluffy14315783fluff__y
fluidizer2242653fluidizer
flunker14389363flu_nker
flunkie1434513flunkie_
flunkies1536393flunkies
flurried12235283flurried
flurries11188913flurries
flusher133012273flu_sher
fluster103913063flu_ster
fluter95316863flu__ter
flutter104012093flu_tter
flytier13356503fl_ytier
fruitier1136593fruitier
frumpier1534173frumpier
fubsier12367763f_ubsier
fuggier12348963f_uggier
fumier11310903f_u_mier
funkier14349983f_unkier
funnier103210173f_unnier
furrier103513663f_urrier
furzier19318103f_urzier
fussier103610673f_ussier
fustier104213933f_ustier
fuzzier18256523f_uzzier
gauffer1474423gauff_er
gluier7310263glu__ier
glumpier1334873glumpier
gruffer1475793gruff_er
gulfier1137793_gulfier
iffier1236763__iffier
kludgier1432463kludgier
klutzier2142193klutzier
leafier10329833_leafier
loftier1037763_loftier
lucifer1234603_lucifer
luckier133811533_luckier
luffed133810823_luff_ed
luffing143310103_luffing
lumpier113410143_lumpier
lunier64617603_lu_nier
lustier73813503_lustier
luthier1038233_luthier
miffier1537023_miffier
muffler15398343_muffler
pluckier16295073pluckier
plumier113510043plu_mier
plummier1434123plummier
plunkier14305323plunkier
plushier1375193plushier
puffer144610733_puff_er
ruffler13369723_ruffler
rufflier1434013_rufflier
scruffier1743303scruffier
scuffer15328883scuff_er
scuffler16286703scuffler
scurfier13267053scurfier
shuffler17306803shuffler
sludgier1034823sludgier
sluffed14308303sluff_ed
sluffing15247303sluffing
slummier1235473slummier
slushier1135983slushier
sluttier836453sluttier
sniffier14356643sniffier
snuffer13318853snuff_er
snuffler14317413snuffler
snufflier1543303snufflier
spiffier16255883spiffier
squiffier2442843squiffier
stuffer13349793stuff_er
suffer124314513_suff_er
sufficer16225823_sufficer
surfier102613543_surfier
tuftier1096603_tuftier
turfier10249793_turfier

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 Limit1461621367.31319986.6
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.79622920.9
 
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.