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

369 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
gipsies103990(None) 
gipsied1135871gipsied
gypsies1335951gypsies
biopsies1237382biopsies
cissies94116152cissies
giddies103713362giddies
gillies84120962gillies
gimmies123010112gimmies
girlies83013702girlies
girshes11248292girshes
guppies123310522guppies
gussies82813302gussies
gypsied1443262gypsied
hippies142813742hippies
hissies103915822hissies
missies93423982missies
popsies112816462popsies
sissies73716602sissies
tipsier9268892tipsier
tipsiest10228952tipsiest
yippies14279292yippies
aisles64721143ai_sles
applies11311213applies
apses76823913_aps_es
apsides103911303_apsides
apsis75718293_apsi_s
aspises9611643aspises
bialies93618413bialies
biases84618433bias_es
biasses94911653biasses
biddies113514493biddies
biffies152710853biffies
biggies113813523biggies
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
biopsied1344593biopsied
birdies104016213birdies
birkies133712433birkies
birses84717733birs_es
bises75435623bi_s_es
bitsier9379073bitsier
bitsiest102610063bitsiest
bossies94116833bossies
buppies133011063buppies
busies85525263_busies
capsids1239333capsids
capsizes2147203capsizes
chippies17309753chippies
cities84524853ci_ties
civies114116443ci_vies
civvies1555843civvies
copies104130303cop_ies
copses104922473cops_es
cosies84932153_cosies
daisies84217093daisies
dassies84418663dassies
depsides1238503depsides
diapsids1244753diapsids
diaries83321953diaries
dickies143416343dickies
didies84621833di_dies
dieses75218693dies_es
diesis74013493diesi_s
dillies84122163dillies
dingies93618243dingies
dinkies123716033dinkies
diopsides1345283diopsides
diploes101111493diploes
dipodies1238413dipodies
dipoles101013753dipoles
dippier123111393dippier
dippiest132511133dippiest
dipsades1246493dipsades
dipsas9359893dips_as
dipshits1445263dipshits
dipsos95310053dips_os
dirties83119383dirties
dishes104622653di_shes
dismes95617673di_smes
disses75225963di_sses
ditsier83010293ditsier
ditsiest92111323ditsiest
ditties83116983ditties
divvies1457663divvies
dizzies16279753dizzies
dropsies1138693dropsies
easies64126633_easies
egises7312493egi_s_es
empties11712243empties
espies83716803esp_ies
falsies103515013falsies
fifties132111083fifties
fillies103420253fillies
finises10312903finises
fipples14298653fipples
fishes125221343fi_shes
flimsies1335783flimsies
gabies93820733g_abies
gaieties9310183gaieties
gallies84122713gallies
gapes86030823gap__es
gaposis1038423gaposi_s
gaposises1245523gaposises
gappier12369843gappier
gappiest13259473gappiest
gases65633993g_as_es
gashes105725153g_ashes
gasses75724783g_asses
gassier83812573gassier
gassiest93212523gassiest
gaudies9311973gaudies
gausses8308693gausses
gawkies15429123gawkies
gawsie1038463gawsie_
genies75324943g_enies
gessoes838293gessoes
gestes75721393g_estes
ghazies2036913ghazies
ghillies12408663ghillies
gibbsites1442013gibbsites
gibes84422523gi__bes
gibsons1045043gibsons
giddied11257713giddied
giddier10308723giddier
giddiest11298553giddiest
gies55641423g___ies
giftees11306513giftees
giggles103312933giggles
gigues8129003gi_gues
gillie74816943gillie_
gillied95512313gillied
gimmes113010903gi_mmes
gimmie11298183gimmie_
gimpier12247943gimpier
gimpiest1338473gimpiest
ginnier8298983ginnier
ginniest92610513ginniest
ginzoes1735433ginzoes
gipons9389603gip_ons
gipped124815903gip_ped
gipper114215303gip_per
gippers123212083gippers
gipping133813123gipping
gips75632923gip___s
gipsy11579543gips__y
gipsying1533373gipsying
girdles92210003girdles
girlie73711463girlie_
girlier8289523girlier
girliest93010403girliest
gismos957183gi_smos
gists66026193gi_s_ts
gites65630183gi__tes
gives95324873gi__ves
glasses84414273glasses
glassies94012273glassies
glimpses1343953glimps_es
glories81915913glories
glosses84014123glosses
glossies93311253glossies
gnashes11419573gnashes
gnoses76515163gnos_es
gnosis75711213gnosi_s
goalies8316023goalies
gobies95418063g_obies
goodies93516993goodies
goonies83618333goonies
gooses75723053goos_es
goosier83512563goosier
goosiest92911823goosiest
gorses74723293gors_es
gorsier83811073gorsier
gorsiest92511133gorsiest
gossips1035903gossips
grasses84117343grasses
gravies11314093gravies
grilses8319153grils_es
gripes94619873grip__es
gripier103210323grip_ier
gripiest11289633grip_iest
grippes124810373grip_pes
grippier1355203grippier
grippiest1435143grippiest
grosses84517683grosses
guesses8169373guesses
guipures1143733guipures
guises74216313guis_es
gullies84717313gullies
gunnies83413123gunnies
gurries83515953gurries
gurshes112210033gurshes
gushes104719033g_ushes
gussie72910153gussie_
gussied9267193gussied
gutsier8389823gutsier
gutsiest92610583gutsiest
gypster1333953gypster
gypsters1434023gypsters
gypsums1541923gypsums
hickies163614743hickies
hinnies103615103hinnies
hiplines13310593hiplines
hippie132811243hippie_
hippier143212103hippier
hippiest152611613hippiest
hipster12288783hipster
hipsters13268793hipsters
hirsles101510073hirsles
hisses94719353hi_sses
hissier103410503hissier
hissiest112911093hissiest
hussies103213293hussies
ibises83610543_ibises
immies102412443_immies
implies11312123implies
indies73822783_indies
insides8512653_insides
irises64221173_irises
isles54220563_i_sles
isseis638563_isseis
issues648803_issues
ivies84215763_i_vies
jiffies20327473jiffies
jimmies18328783jimmies
kiddies133412283kiddies
killies113318113killies
kilties113014143kilties
kipskins1343263kipskins
kisses104217333ki_sses
kitties113213623kitties
koppies153210013koppies
lapises93513463lapises
lapses85217693laps_es
lassies74420103lassies
liaises7311053liaises
lilies63021413li_lies
limpsier1234433limpsier
limpsiest1344793limpsiest
lindies8416583lindies
lipases9209483lipases
lipides103810623lipides
lipids94310923lip_ids
lipins85016883lip_ins
lipoids1038233lipoids
lippier112710573lippier
lippiest122310613lippiest
lisles63416283li_sles
middies113116153middies
minnies93617363minnies
mioses84318853mios_es
miosis83615163miosi_s
mises74740563mi_s_es
mislies92922283mislies
misses85130873mi_sses
missiles103015083missiles
missis84417503missi_s
missises103513693missises
missives133212843missives
mitises9315543mitises
nappies114613393nappies
newsies101310383newsies
nifties102612503nifties
ninnies73713613ninnies
nippier11319833nippier
nippiest12279973nippiest
nipples11319663nipples
niseis63512023ni_seis
nixies135313873ni_xies
opsins8411713_opsins
palsies94420273palsies
pansies94521983pansies
pappies103214823pappies
patsies93919483patsies
pepsines1239883pepsines
pepsins11310433pepsins
pies66949603__p_ies
pieties9419223pieties
piggies113813483piggies
pigmies122610993pigmies
pigsties1139783pigsties
pinkies133818263pinkies
pinnies93318443pinnies
pipages1289423pipages
pipes96030143pip__es
pipier104913983pip_ier
pipiest113114493pip_iest
pipits104713063pip_its
pipkins15328183pipkins
pippins10319753pippins
pishes114722103pi_shes
pisses84525083pi_sses
pistes85325633pi_stes
pities83828083pi_ties
pixies154915513pi_xies
plies74526513__plies
poesies93217403poesies
poppies102816193poppies
popsie103013053popsie_
posies84431433_posies
potsies93019483potsies
pries74339533__pries
prissies101712003prissies
psis68120343__psi_s
puppies103212613puppies
pussies93615693pussies
quinsies1737623quinsies
replies94521043replies
rinses64720383rins_es
ripes75435773rip__es
ripostes10239083ripostes
ripples113513293ripples
ripsaws1243823ripsaws
riptides1136413riptides
rises55244043ri_s_es
sassies74719263sassies
sepses84515883seps_es
sepsis83011293sepsi_s
shipsides1544883shipsides
sickies133717503sickies
silkies113715693silkies
sillies73425083sillies
sipes76036953sip__es
sises55233833si_s_es
sisses64520603si_sses
sissier73711363sissier
sissiest83412353sissiest
sixties14310973sixties
sophies12314613sophies
spies76037623_sp_ies
tansies74521243tansies
tapises92914013tapises
tassies74918933tassies
tidies74721833ti_dies
tipis76019923tip_i_s
tippier113210543tippier
tippiest122310013tippiest
tipples112811253tipples
tipsily1236043tipsily
tipsiness1135703tipsiness
tipster9299053tipster
tipsters10278513tipsters
tiptoes939173tiptoes
tissues737463tissues
titties73617363titties
tizzies15287893tizzies
topsides1137203topsides
upsides10319633_upsides
upsizes18297163_upsizes
vichies15310623vichies
vises84427773vi_s_es
visits9311423vi_sits
whimsies1635193whimsies
widdies123514033widdies
wienies102213683wienies
willies103920153willies
wipes104827083wip__es
wises85633193wi_s_es
wishes124920953wi_shes
wispier12249403wispier
wispiest1339513wispiest
wisses94619603wi_sses
withies133913543withies
wussies103411083wussies
yipes106017843yip__es
yippie13277843yippie_
yuppies14339263yuppies
zippier20308193zippier
zippiest21248093zippiest

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 Filter1786911340270.423422437.4
2DLD Change Limit1340273696.54620474.6
3Display Results3693690.1402635.7
 (SQL Overall)1786913697.10925135.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.