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

181 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
gnattier93426(None) 
nattier73614621_nattier
battier93515712_battier
brattier1047662brattier
cattier93317072_cattier
chattier1337512chattier
fattier103513462_fattier
gnarlier9255162gnarlier
gnattiest1035382gnattiest
grittier9316262grittier
grottier9316672grottier
guttier83911102g_uttier
knottier12203982knottier
nastier74115292_nastier
natter64420742_natt_er
nettier74211812_nettier
nittier73512242_nittier
nuttier73112022_nuttier
rattier74015592_rattier
scattier10267582scattier
snottier8217372snottier
tattier74216242_tattier
antsier7410773an_tsier
artier63419733__artier
attire62412383__attire
batter84928873_batt_er
battler94113383_battler
bittier94211663_bittier
blastier10249493blastier
blatter94415653blatt_er
blottier10336413blottier
cattie85221013_cattie_
catties94023053_catties
chatter124416643chatt_er
clatter94014973clatt_er
cottier93814173_cottier
craftier1376193craftier
dottier83910923_dottier
draftier1285263draftier
fatter94523213_fatt_er
fatties103018203_fatties
featlier1136453featlier
flatter103815963flatt_er
frettier1156593frettier
gabbier12379633g_abbier
gaiter73819503g_ait_er
gambier124711963g_ambier
gamier93617933g_a_mier
gammier123711193g_ammier
ganglier1047603ganglier
gantries91413783gantries
gappier12369843g_appier
garter74420513g_art_er
gassier83812573g_assier
gaster75027353g_ast_er
gater64533643g_a_t_er
gather104115853g_a_ther
gaudier938453g_audier
gauzier1735633g_auzier
gawkier15326523g_awkier
getter74117613g_ett_er
ghastlier1342893ghastlier
ghostier1235383ghostier
glacier103911293gla_cier
gladier93810993gla_dier
gladlier1034343gladlier
glairier944833glairier
glarier84112203gla_rier
glassier9289083glassier
glazier17409353gla_zier
gleetier934913gleetier
glintier945703glintier
glitter84211803glitt_er
glitzier1833593glitzier
gnathic1344843gnathi_c
gnathion1243443gnathion
gnathite1244483gnathite
gnathites1344233gnathites
gnatlike1334743gnatlike
gnatty10336483gnatt__y
gnawer10386953gna__wer
goutier82612353g_outier
grabbier13316653grabbier
grafter114211153graft_er
grainier9218893grainier
granter84117133grant_er
grapier103712603gra_pier
grassier9349283grassier
grater74625433gra_t_er
gratifier1345823gratifier
grazier173611133gra_zier
gritter83913353gritt_er
groutier9297173groutier
guiltier934493guiltier
gustier83813863g_ustier
gutsier8389823g_utsier
gutter73817703g_utt_er
guttler8369163g_uttler
hastier103916623_hastier
hatter94724873_hatt_er
heartier1139093heartier
heathier1438343heathier
jettier14358693_jettier
knitter11348133knitt_er
knotter11317643knott_er
lathier10310833_lathier
latter65027893_latt_er
maltier93015483_maltier
matier84321523_ma_tier
matter84325343_matt_er
meatier93214613mea_tier
naggier9309153_naggier
nappier114411173_nappier
nasties73520493_nasties
natters73718063_natt_ers
nattiest83215353_nattiest
nattily103610323_nattily
netter63722023_nett_er
nettler7349503_nettler
nettlier864813_nettlier
niftier10328713_niftier
nutsier7329253_nutsier
nutter63918053_nutt_er
partier93520713_partier
pastier94320383_pastier
patter84628263_patt_er
pattie84020963_pattie_
patties93425143_patties
peatier94017233pea_tier
pettier94213613_pettier
phatter123810203phatt_er
platier93716293pla_tier
platter93917413platt_er
plottier10327263plottier
pottier93516493_pottier
prattler10166343prattler
prettier1069043prettier
puttier93314503_puttier
quartier1737543quartier
ratter64326313_ratt_er
rattler74012743_rattler
ruttier73412283_ruttier
saltier74318633_saltier
scantier10309983scantier
scatter93815173scatt_er
shatter103615693shatt_er
shittier1137303shittier
slatier74016813sla_tier
slittier837003slittier
sluttier836453sluttier
smatter93613333smatt_er
smuttier1035213smuttier
snaggier10136303snaggier
snakier112810003sna_kier
snappier1266213snappier
snarkier12336513snarkier
snarlier8278183snarlier
snatcher13167753snatcher
snatchier1455353snatchier
snazzier1642483snazzier
snootier8278373snootier
snoutier8206973snoutier
spatter94016523spatt_er
spottier10207303spottier
squattier1843713squattier
swatter104113323swatt_er
tartier74123263_tartier
tastier711817093_tastier
tatter64024573_tatt_er
tattie64817513_tattie_
tatties74120343_tatties
tattler73112213_tattler
toastier846893toastier
unattired1045083unattired
vastier103613203_vastier
wartier103413913_wartier
watter93221983_watt_er
wittier103910823_wittier
wrathier1435903wrathier
yatter94116213_yatt_er
yeastier1135393yeastier

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.1701051123.5
2DLD Change Limit1461621818.05018156.8
3Display Results1811810.0762381.6
 (SQL Overall)1786911818.29621539.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.