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

253 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
blottier1033641(None) 
blotter94612851blott_er
plottier10327261plottier
battier93515712b_attier
bittier94211662b_ittier
blastier10249492blastier
blatter94415652blatt_er
bloater94013422bloat_er
blockier1666132blockier
bloodier1136822bloodier
bloomier1275782bloomier
blotchier1643212blotchier
blotted103911832blott_ed
blotters104110982blott_ers
blottiest11286832blottiest
blotting113910432blotting
blousier1055662blousier
blowier1248942blo_wier
blowsier1335062blowsier
blowzier2233412blowzier
bottler94211882b_ottler
brattier1047662brattier
clothier1335362clothier
cottier93814172_cottier
dottier83910922_dottier
floatier1136982floatier
grottier9316672grottier
knottier12203982knottier
loftier1037762_loftier
lotter64025602_lott_er
plotter94113662plott_er
plotties103111412plotties
pottier93516492_pottier
slittier837002slittier
slotter73314452slott_er
sluttier836452sluttier
snottier8217382snottier
spottier10207312spottier
allotter866473allott_er
batter84928873b_att_er
battler94113383b_attler
belittler1142493belittler
better84723703b_ett_er
biotite9311033biotite_
biotites10310083biotites
bitsier9379073b_itsier
bitter84622673b_itt_er
blaster94017303blast_er
blastie92411393blastie_
blasties102113633blasties
blather125314203bl_ather
blatted104812713blatt_ed
blatters104414093blatt_ers
blatting114111653blatting
blearier1037333blearier
bleater94515303bleat_er
blether12459913bl_ether
blister94415313blist_er
blither124812173bl_ither
blitzer18447663bl_itzer
bloated104513433bloat_ed
bloaters103311023bloat_ers
bloating113512813bloating
blocker15419923blo_cker
blogger11448313blo_gger
blonder104011943blo_nder
bloodied1245973bloodied
bloodies11310163bloodies
blooie83913193blo_oie_
bloomer11419813blo_omer
blooper11358533blo_oper
blotched1635653blotched
blotches1537433blotches
blotto8198443blott__o
blotty11178343blott__y
blower115316573blo__wer
bluesier1034943bluesier
blunter94512033blunt_er
blurrier1035163blurrier
blurter9419833blurt_er
bluster94215313blust_er
boater84622093b_oat_er
boggier113711583b_oggier
bolster93713423bolst_er
bolter83920753b_olt_er
bonier84321993b_o_nier
bonnier94711313b_onnier
boomier113312183b_oomier
booster94314553boost_er
bootie85421163b_ootie_
booties94124613b_ooties
boozier18349013b_oozier
boskier13309173b_oskier
bossier93712423b_ossier
botcher143613223b_otcher
botchier15287143b_otchier
bother115218063b_o_ther
bothies12414783b_othies
bottle84916073b_ottle_
bottled104611233b_ottled
bottlers103810013b_ottlers
bottles94216273b_ottles
bottomer1245103b_ottomer
bouvier1277433b_ouvier
boxier154311743b_o_xier
brittler10165983brittler
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
brother123311333bro_ther
brownier13226913brownier
bustier93916153b_ustier
butter84724233b_utt_er
butties93217953b_utties
cattier93317073_cattier
chattier1337513chattier
clatter94014973clatt_er
cloddier1234063cloddier
cloggier1244253cloggier
clothiers1443423clothiers
clotted104011823clott_ed
clotting113110643clotting
cloudier1135053cloudier
clouter93511693clout_er
clutter94211663clutt_er
cotter84926673_cott_er
cottiers10399153_cottiers
dotier73917033_do_tier
dotter74419343_dott_er
fattier103513463_fattier
flatter103815963flatt_er
flintier1136393flintier
flirtier1144893flirtier
flitter103413903flitt_er
floater104413353float_er
flockier1745343flockier
floppier1554633floppier
flossier11326973flossier
flouter104311343flout_er
flutier103011553fl_utier
flutter104012093flutt_er
flytier13356503fl_ytier
footier104115113_footier
frettier1156593frettier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
ghostier1235383ghostier
gleetier934913gleetier
glintier945703glintier
glitter84211803glitt_er
glitzier1833593glitzier
gloater83711013gloat_er
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
glottic1036653glotti_c
glottides1163833glottides
glottis837173glotti_s
glottises1084953glottises
gnattier934263gnattier
goutier82612353_goutier
grittier9316263grittier
groutier9297173groutier
guttier83911103_guttier
hootier104915353_hootier
hotter94720083_hott_er
hottie92514383_hottie_
hotties103016963_hotties
jettier14358693_jettier
joltier14318493_joltier
jotter134315633_jott_er
klutzier2142193klutzier
knotter11317643knott_er
lathier10310833_lathier
latter65027893_latt_er
letter63722583_lett_er
lintier73613803_lintier
litter64324853_litt_er
littler7348553_littler
loamier9349163_loamier
loather103711003_loather
lofter94614723_loft_er
loggier93811143_loggier
logier75015733_lo_gier
loiter64619173_loit_er
loonier73312683_loonier
loopier93711193_loopier
looter64222323_loot_er
loppier11369723_loppier
lotte54923853_lott_e_
lotted74222403_lott_ed
lotters73921063_lott_ers
lottery10389833_lott_ery
lottes65322753_lott_es
lotting82917753_lotting
lousier72411623_lousier
lowlier10338903_lowlier
lustier73813503_lustier
luthier1038233_luthier
mothier121910213_mothier
motlier92010583_motlier
mottler94410343_mottler
nattier73614623_nattier
nettier74211813_nettier
nittier73512243_nittier
nuttier73112023_nuttier
otter54423973__ott_er
pettier94213613_pettier
platier93716293pl_atier
platter93917413platt_er
plotted104612373plott_ed
plotters104011553plott_ers
plottiest11287833plottiest
plotting113011013plotting
potter83926983_pott_er
potties93723543_potties
poutier93215323_poutier
prettier1069043prettier
puttier93314503_puttier
rattier74015593_rattier
rootier74915393_rootier
rotter64325463_rott_er
ruttier73412283_ruttier
scattier10267583scattier
scottie937463scottie_
scotties1039753scotties
shittier1137313shittier
slatier74016813sl_atier
sleetier837883sleetier
slitter73615873slitt_er
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slotted84613883slott_ed
slotters84012403slott_ers
slotting92612613slotting
smuttier1035213smuttier
snootier8278383snootier
snoutier8206973snoutier
sootier73916613_sootier
sportier102010053sportier
spotter94514883spott_er
swotter10399473swott_er
tattier74216243_tattier
toothier1136423toothier
totter65021463_tott_er
trotter73312253trott_er
troutier8277153troutier
wittier103910823_wittier
zloties1639913zlo_ties
zootier163611173_zootier

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.750238254.7
2DLD Change Limit1461622537.17320376.7
3Display Results2532530.0932720.4
 (SQL Overall)1786912538.01622291.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.