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

228 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
gipsied113587(None) 
gipsies1039901gipsies
gypsied1443261gypsied
biopsied1344592biopsied
giddied11257712giddied
gillied95512312gillied
gipped124815902gip_ped
gussied9267192gussied
gypsies1335952gypsies
tipsier9268892tipsier
agisted938203agi_sted
airshed11258533airshed
aisled74516183ai_sled
applied1247483applied
biased94012223bias_ed
biassed10418703biassed
bilsted1038033bilsted
biopsies1237383biopsies
biped104718833bip__ed
birdied11329433birdied
bitsier9379073bitsier
busied95117223_busied
capsid11312413capsi_d
capsized2255493capsized
cissies94116153cissies
cisted95217523ci_sted
citied94014143ci_tied
copied114618563cop_ied
cosied94819883_cosied
daisied93410013daisied
depside1138403depside
diapsid1146703diapsi_d
diopside1245643diopside
dipped123517493dip_ped
dippier123111393dippier
dirtied93210853dirtied
disced104914653di_sced
dished114318713di_shed
disked125015763di_sked
dissed85220183di_ssed
ditsier83010293ditsier
divvied1544813divvied
dizzied17236133dizzied
dropsied1234963dropsied
emptied1297393emptied
espied9359773esp_ied
fished134316313fi_shed
fissiped1444153fissiped
fisted104218703fi_sted
gallied94115003gallied
gaped96123533gap__ed
gapeseed1243253gapeseed
gapped124217123gap_ped
gappier12369843gappier
gashed116321973g_ashed
gasped104814293g_asped
gassed85217633g_assed
gassier83812573gassier
gasted84821583g_asted
gawsie1038463gawsie_
gessoed935743gessoed
ghosted1236273ghosted
gibbed124512353gi_bbed
gibed96215963gi__bed
giddier10308723giddier
giddies103713363giddies
gied64631983g___ied
gifted114510703gi_fted
gigged104112293gi_gged
giggled114010073giggled
gilded94413223gi_lded
gilled84521633gi_lled
gillie74816943gillie_
gillies84120963gillies
gimmie11298183gimmie_
gimmies123010113gimmies
gimped123911473gi_mped
gimpier12247943gimpier
ginned83813983gi_nned
ginnier8298983ginnier
gipper114215303gip_per
gipping133813123gipping
gips75632923gips___
gipsy11579543gips__y
gipsying1533373gipsying
girded93712493gi_rded
girdled10217453girdled
girlie73711463girlie_
girlier8289523girlier
girlies83013703girlies
girned84010513gi_rned
girshes11248293girshes
girted83912873gi_rted
girthed12266243girthed
gitted84015053gi_tted
glassed93710433glassed
glimpsed1442773glimps_ed
gloried9169523gloried
glossed94410073glossed
gnashed12317523gnashed
goosed86817033goos_ed
goosier83512563goosier
gorsier83811073gorsier
gossiped1263513gossiped
grasped11409063grasped
grassed93812793grassed
griped104114713grip__ed
gripier103210323grip_ier
gripped13419343grip_ped
grippier1355203grippier
grossed93812253grossed
guessed9176603guessed
guested9157713guested
guised84612173guis_ed
gullied93812063gullied
guppies123310523guppies
gushed114816243g_ushed
gussie72910153gussie_
gussies82813303gussies
gusted84316723g_usted
gutsier8389823gutsier
gypped15377113gyp_ped
gypster1333953gypster
hinnied11348103hinnied
hipped144317693hip_ped
hippie132811243hippie_
hippier143212103hippier
hippies142813753hippies
hipster12288783hipster
hirsled11118113hirsled
hispid1238173hispi_d
hissed104114453hi_ssed
hissier103410503hissier
hissies103915823hissies
histed104420243hi_sted
implied1238623implied
inside7613453_inside
irised73913153_irised
isled64615993_i_sled
issued746723_issued
ivied94710523_i_vied
jimmied19275033jimmied
kipped153114573kip_ped
kissed114412853ki_ssed
lapsed94712583laps_ed
liaised837113liaised
lilied73913213li_lied
limpsier1234433limpsier
linseed838203linseed
lipid85916173lip_i_d
lipide93511063lip_ide
lipoid9411043lipoi_d
lipped114419543lip_ped
lippier112710573lippier
lisped94113423li_sped
listed74322833li_sted
lopsided1244253lopsided
midsized2144733midsized
misfed124113023mi_sfed
misled94719313mi_sled
mispled12310463mispled
missed94423603mi_ssed
missies93423983missies
misted93625823mi_sted
nipped113615853nip_ped
nippier11319833nippier
nippled12307643nippled
oilseed835783oilseed
palsied102911303palsied
pied75035363__p_ied
piped105123163pip__ed
pipier104913983pip_ier
pipped104516543pip_ped
pished124817063pi_shed
pissed94816933pi_ssed
pitied94017253pi_tied
plied85118593__plied
poppied11388983poppied
popsie103013053popsie_
popsies112816463popsies
pried84426863__pried
quinsied1845043quinsied
replied103914453replied
rinsed75016353rins_ed
riped85226433rip__ed
ripened1038203ripened
riposted11216933riposted
ripped114419013rip_ped
rippled123110273rippled
ripsawed1442533ripsawed
riptide1036883riptide
risked115514633ri_sked
shipside1445033shipside
siped84927683sip__ed
sipped113720633sip_ped
sissier73711363sissier
sissies73716603sissies
spied85427713_sp_ied
tidied83613273ti_died
tipped114418263tip_ped
tippier113210543tippier
tippled12358393tippled
tipsiest10228953tipsiest
tipsily1236043tipsily
tipster9299053tipster
tiptoed1036143tiptoed
tissued835583tissued
topside1037733topside
upside9289803_upside
upsized19246253_upsized
visaed104110503vi_saed
vised95518763vi_s_ed
viseed105310983vi_seed
visited1168773vi_sited
whimsied1743113whimsied
willied114611563willied
wiped114722083wip__ed
wised95123343wi_s_ed
wished134417513wi_shed
wisped123411893wi_sped
wispier12249403wispier
wissed104114643wi_ssed
wisted104120273wi_sted
yipped143613283yip_ped
yippie13277843yippie_
yippies14279293yippies
zipped203612983zip_ped
zippier20308193zippier

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.406440125.6
2DLD Change Limit1340272286.14021828.5
3Display Results2282280.0802850.0
 (SQL Overall)1786912286.62626968.2
 
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.