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

223 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
gitterns932657(None) 
bitterns10428951bitterns
citterns10318121citterns
gittern8337501gittern_
bittern94810682bittern_
bitters94920362bitter_s
cisterns10369572cisterns
citherns13338872citherns
cittern9339142cittern_
fitters104517752fitter_s
getters84216102getter_s
glitters93710542glitter_s
gritters94210632gritter_s
gutters83715512gutter_s
hitters104717592hitter_s
interns73116772_interns
jitters144314472jitter_s
kittens11347582kitte_ns
litters73422572litter_s
mittens9349882mitte_ns
patterns10439942patterns
ritters74020622ritter_s
sitters74221552sitter_s
titters74219622titter_s
zitherns20376132zitherns
attorns738443_attorns
battens95313263batte_ns
batters94626013batter_s
betters94422093better_s
bisters93922613bister_s
biters83925243bi_ter_s
bitten84715123bitte_n_
bitter84622673bitter__
bittered112711833bittered
bitterer10309773bitterer
bitterest1147713bitterest
bittering122511993bittering
bitterish1446133bitterish
bitterly1335603bitterly
bitterness1245553bitterness
bitternut1144323bitternut
bitternuts1242723bitternuts
butters94521723butter_s
chitters133711173chitter_s
cistern93310703cistern_
cisterna10376363cisterna
citers85022983ci_ter_s
cithern12489913cithern_
cithers124315773cither_s
cithrens13355933cithrens
cotters94323443cotter_s
critters103511323critter_s
cutters94218963cutter_s
dieters83216433dieter_s
dipterans1245723dipterans
discerns1138163discerns
dithers114016153dither_s
dotters83715973dotter_s
emitters10349643emitter_s
externs1438233_externs
fattens105111713fatte_ns
fetters103517903fetter_s
fifteens1442753fifteens
filters103816553filter_s
fitter94120033fitter__
flitters114312173flitter_s
fritters113810783fritter_s
gaiters83516543gaiter_s
garters84218233garter_s
gasters85624293gaster_s
gaters74728643g_ater_s
gathers114315073gather_s
getter74117613getter__
gettered10258613gettered
gettering112310033gettering
gibbers124710983gibber_s
gibers95114663gi_ber_s
giftees11306513gifte_es
gilberts1134183gilberts
gilders94212463gilder_s
gillers84216903giller_s
gingers94118643ginger_s
ginners84314223ginner_s
gippers123212083gipper_s
girders9379943girder_s
girns64516803gi___rns
gites65630183gi_te__s
gitted84015053gitte__d
gittin72910553gitt_in_
gitting93215703gitt_ing
givens10379733gi_ve_ns
givers104817713gi_ver_s
glistens9366593gliste_ns
glisters93912603glister_s
glitter84211803glitter__
glittered11195403glittered
glittering1296003glittering
glittery12375613glitter_y
glutens8437593glute_ns
goiters84014443goiter_s
gotten73410113gotte_n_
governs1136103g_overns
graters85419743grater_s
grifters12389233grifter_s
gristers94013403grister_s
gritter83913353gritter__
gutter73817713gutter__
guttered10259163guttered
guttering112410443guttering
gutterings12224913gutterings
guttery11427763gutter_y
guttlers9306933guttler_s
hatters104221523hatter_s
hinters103719583hinter_s
hitter94419863hitter__
icterus936073_icterus
intern64016543_intern_
interne73218143_interne
internes82721233_internes
inters64328053_inter_s
inturns73210133_inturns
jilters144211963jilter_s
jitter133314993jitter__
jittered16267223jittered
jittering17218423jittering
jittery17346443jitter_y
jotters143413803jotter_s
kilters113813603kilter_s
kiters105218593ki_ter_s
kitten104611483kitte_n_
knitters12336623knitter_s
lanterns838303lanterns
lattens75014673latte_ns
lecterns1035943lecterns
letters73819853letter_s
lifters104313783lifter_s
linters73822633linter_s
listens74014133liste_ns
listers74026533lister_s
liters65429883li_ter_s
litten64014873litte_n_
litter64324853litter__
littered92511383littered
litterer82810173litterer
litterers9228193litterers
littering102411983littering
littery103710493litter_y
lotters73921063lotter_s
lutherns1136293lutherns
matters94421753matter_s
midterms13284863midterms
milters93619093milter_s
minters93822473minter_s
misterms123711353misterms
misters93927513mister_s
miters84328783mi_ter_s
mithers123516733mither_s
mitten83914093mitte_n_
mutters94117143mutter_s
natters73718063natter_s
netters73618583netter_s
niters64624213ni_ter_s
nutters74215433nutter_s
omitters10277653omitter_s
otters64021513_otter_s
outturns835913outturns
pasterns104112623pasterns
pattens95414923patte_ns
pattern93712053pattern_
patters94825193patter_s
petters93722363petter_s
pitiers93812653pitier_s
posterns102713723posterns
potteens10256793potteens
potters94024343potter_s
putters94219193putter_s
quitters17238523quitter_s
ratteens8256053ratteens
rattens74213403ratte_ns
ratters74422473ratter_s
rioters73615513rioter_s
ritter63822423ritter__
rotters74421393rotter_s
salterns8388903salterns
setters73822063setter_s
sifters103714793sifter_s
sinters74024083sinter_s
sisters73721593sister_s
sithens1039383sithe_ns
sitten64113823sitte_n_
sitter63323383sitter__
sixteens1542943sixteens
skitters12349553skitter_s
slatterns935363slatterns
slitters84014133slitter_s
spitters104113383spitter_s
sterns64616763__sterns
tatters74520483tatter_s
terns55226873___terns
tetters74320473tetter_s
tilters73315953tilter_s
tinters74221113tinter_s
titers64526413ti_ter_s
titfers10318933titfer_s
tithers104216733tither_s
titter63421163titter__
tittered9239493tittered
titterer8268523titterer
titterers9236993titterers
tittering102310313tittering
totters74618733totter_s
twitters11296773twitter_s
utters63817123_utter_s
vetters104016323vetter_s
westerns11328963westerns
wetters103817753wetter_s
whitters14359403whitter_s
winters103720483winter_s
withers134417753wither_s
wiverns13366963wi_verns
yatters103914623yatter_s
zithern19447023zithern_
zithers193911973zither_s

Search took 7 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 Limit1461622236.33023090.4
3Display Results2232230.0762934.2
 (SQL Overall)1786912236.82626178.0
 
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.