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

266 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
giftees1130651(None) 
giftee103512081giftee_
fifteen1343922fifteen
fifteens1442752fifteens
fifties132111082fifties
gifted114510702gift_ed
giftless1245172giftless
gifts96214962gift__s
gites65630182gi_t_es
goatees82710442goatees
grifters12389232grifters
lifters104313782lifters
listees73416672listees
nifties102612502nifties
sifters103714792sifters
afters94717073_afters
bifaces1448063bifaces
biffies152710853biffies
bisters93922613bisters
bistres94017213bistres
biters83925243bi_ters
bites75641173bi_t_es
bitters94920363bitters
bootees94114473bootees
citers85022983ci_ters
cites74435593ci_t_es
cities84524853ci_ties
coatees93816553coatees
coffees15329573coffees
dieters83216433dieters
differs14339973differs
dirties83119383dirties
dites66339153di_t_es
ditties83116983ditties
ditzes163212423di_tzes
draftees12225253draftees
drifters12417913drifters
evictees1344583evictees
fees76450603__f_ees
fetes85630143__fetes
fifers125414923fif_ers
fifes114822393fif__es
fifths15406543fift_hs
filters103816553filters
fitters104517753fitters
flees85828753__flees
frees86131393__frees
gaffers14428713gaffers
gaffes134811103gaf_fes
gaieties9310183gaieties
gaiters83516543gaiters
gametes10312253gametes
garters84218233garters
gasters85624293gasters
gaters74728643g_aters
gates65939513g_at_es
gees55647883g___ees
gelees74116263g_elees
genteel836753genteel
gentes75324163gent_es
gentles83714343gentles
gestes75721393gest_es
getters84216103getters
ghees95215553g__hees
giantess933893giantess
gibbers124710983gibbers
gibbets12417723gibbets
gibers95114663gi_bers
gibes84422523gi__bes
giblets103210423giblets
giddies103713363giddies
gies55641423gi___es
gift86735793gift___
giftables1572593giftables
giftedly1642933giftedly
giftedness1543683giftedness
gifting123810893gifting
giftwares1642213giftwares
giggles103312933giggles
giglets93211553giglets
gigues8129003gi_gues
gilders94212463gilders
gillers84216903gillers
gillies84120963gillies
gilts64924263gilt__s
gimels938893gi_mels
gimlets10338433gimlets
gimmes113010903gi_mmes
gimmies123010113gimmies
gingers94118643gingers
ginners84314223ginners
ginzoes1735433ginzoes
gippers123212083gippers
gipsies1039903gipsies
girders9379943girders
girdles92210003girdles
girlies83013703girlies
girshes11248293girshes
girted83912873girt_ed
girthed12266243girthed
girths105612273girt_hs
girts65423623girt__s
gists66026193gist__s
gite55438613gi_t_e_
gits55744593gi_t__s
gitted84015053gi_tted
gittern8337503gittern
gitterns9326573gitterns
givens10379733gi_vens
givers104817713gi_vers
gives95324873gi__ves
glees65027593g__lees
glistens9366593glistens
glisters93912603glisters
glitters93710543glitters
glitzes17367563glitzes
glutens8437593glutens
glutes74517673glut_es
gluteus8386253gluteus
goatee73219533goatee_
goateed9307063goateed
gofers104711513gof_ers
goffers14409213goffers
goiters84014443goiters
goitres8389563goitres
grafters12409193grafters
grantees92510973grantees
graters85419743graters
grates75429893grat_es
grees65132473g__rees
griffes14367923grif_fes
grifted12379583grift_ed
grifter113810493grift_er
grifts104511683grift__s
gristers94013403gristers
gristles9189203gristles
gritters94210633gritters
gumtrees1143883gumtrees
gustoes879873gustoes
gutters83715513gutters
guttles83011933guttles
hafters134614333hafters
hefters134312003hefters
hinters103719583hinters
hirees95117293hi_rees
hitters104717593hitters
inters64328053_inters
istles62814983_istles
items7499613_i_tems
ixtles13217063_ixtles
jiffies20327473jiffies
jilters144211963jilters
jitters144314473jitters
kilters113813603kilters
kilties113014143kilties
kirtles11309663kirtles
kiters105218593ki_ters
kites95432543ki_t_es
kithes135016653ki_thes
kittens11347583kittens
kitties113213623kitties
kittles113012493kittles
lefties10312073lefties
lichees123512783lichees
lifers95617843lif_ers
lifted104413523lift_ed
lifter93814813lift_er
liftmen1234233liftmen
lifts85719063lift__s
lintels73311163lintels
linters73822633linters
listee64223063listee_
listels74212433listels
listens74014133listens
listers74026533listers
liters65429883li_ters
litres65220393li_tres
litters73422573litters
littles73212783littles
lofters103912903lofters
mentees93214503mentees
mestees94617753mestees
milters93619093milters
minters93822473minters
misters93927513misters
miters84328783mi_ters
mites75141803mi_t_es
mitres83922073mi_tres
mittens9349883mittens
mustees94614923mustees
niffers13287363niffers
niftier10328713niftier
niftiest112910073niftiest
niters64624213ni_ters
nites55736343ni_t_es
nitres65519333ni_tres
picotees1247113picotees
pieties9419223pieties
piffles15368763piffles
pintles94118723pintles
pintoes95117713pintoes
pistes85325633pist_es
pities83828083pi_ties
puttees93612913puttees
rafters103715633rafters
riffles133911163riffles
riflers103512193riflers
rifles94217703rif_les
rifted104115313rift_ed
riftless1136943riftless
rifts85718643rift__s
rioters73615513rioters
rites54442553ri_t_es
ritters74020623ritters
ritzes154812943ri_tzes
settees73513633settees
shifters14319863shifters
sickees134514213sickees
sifted104313673sift_ed
sifter94516233sift_er
sifts84918923sift__s
signees83510803signees
sinters74024083sinters
sirees64624583si_rees
sirrees73410573sirrees
sisters73721593sisters
sites56045433si_t_es
sitters74221553sitters
sixteen1434113sixteen
sixteens1542943sixteens
sixtes133612403sixt_es
sixties14310973sixties
snifters11318613snifters
softens10347623softens
softies103414613softies
suttees74114063suttees
swifters14277483swifters
tees45353583___tees
testees74215913testees
tilters73315953tilters
tinters74221113tinters
tiptoes939173tiptoes
titers64526413ti_ters
titfers10318933titfers
tithes94720213ti_thes
titles63719923ti_tles
titres64718933ti_tres
titters74219623titters
titties73617363titties
tittles73413253tittles
toffees13327083toffees
tufters10298353tufters
tutees6514553_tutees
unfrees1048643unfrees
vestees103513173vestees
virtues10338023virtues
vittles103211113vittles
wafters134112813wafters
wifes114522563wif__es
wifeys15425873wif_eys
wiftier13297733wiftier
wiftiest14279173wiftiest
winters103720483winters
wintles103414983wintles
wites85536963wi_t_es
withes124620843wi_thes

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272665.67023637.9
3Display Results2662660.0962770.8
 (SQL Overall)1786912666.18928872.4
 
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.