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 “gypsied” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
gypsied144326(None) 
gipsied1135871gipsied
gypsies1335951gypsies
gipsies1039902gipsies
gussied9267192gussied
gypped15377112gyp_ped
gypster1333952gypster
applied1247483applied
biopsied1344593biopsied
busied95117223_busied
bypassed1642713bypassed
capsid11312413capsi_d
capsized2255493capsized
copied114618563cop_ied
cosied94819883_cosied
daisied93410013daisied
depside1138403depside
dropsied1234963dropsied
emptied1297393emptied
espied9359773esp_ied
gallied94115003gallied
gaped96123533gap__ed
gapeseed1243253gapeseed
gapped124217123gap_ped
gappier12369843gappier
gashed116321973g_ashed
gasped104814293g_asped
gassed85217633g_assed
gassier83812573gassier
gasted84821583g_asted
gawsie1038463gawsie_
gessoed935743gessoed
ghosted1236273ghosted
giddied11257713giddied
gied64631983g___ied
gillied95512313gillied
gipped124815903gip_ped
glassed93710433glassed
gloried9169513gloried
glossed94410073glossed
gnashed12317523gnashed
goosed86817033goos_ed
goosier83512563goosier
gorsier83811073gorsier
gossiped1263513gossiped
grasped11409063grasped
grassed93812793grassed
grossed93812253grossed
guessed9176603guessed
guested9157713guested
guised84612173guis_ed
gullied93812063gullied
guppies123310523guppies
gushed114816243g_ushed
gussie72910153gussie_
gussies82813303gussies
gusted84316723g_usted
gutsier8389823gutsier
gybed125811023gy__bed
gypper14347293gyp_per
gypping16305843gypping
gyps105115023gyps___
gypseian1441603gypseian
gypsters1434023gypsters
gypsum1442853gyps_um
gypsums1541923gypsums
gypsy14636993gyps__y
gypsying1842183gypsying
gypsyish2041593gypsyish
gypsyism1951553gypsyism
gyrated12428413gyrated
gyred105114093gy__red
gyved13568743gy__ved
hyped145313333hyp__ed
hypoed1547923hyp_oed
implied1238623implied
lapsed94712583laps_ed
lopsided1244253lopsided
lysed95011563ly_s_ed
mysid11610693my_si_d
palsied102911303palsied
pied75035363__p_ied
plied85118593__plied
poppied11388983poppied
popsie103013053popsie_
popsies112816463popsies
pried84426863__pried
replied103914443replied
spied85427713_sp_ied
tipsier9268893tipsier
topside1037733topside
typed115815453typ__ed
typier1137333typ_ier
typified1743923typified
upside9289803_upside
upsized19246253_upsized
yessed104511163_yessed

Search took 10 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.1601116818.8
2DLD Change Limit134027979.39014273.4
3Display Results97970.0303233.3
 (SQL Overall)178691979.58018652.5
 
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.