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

132 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
gangster1021577(None) 
gagster9317631ga_gster
gangsters11205731gangsters
ganister9178991ganister
banister10199972banister
canister101710852canister
gagsters10317082ga_gsters
gamester1137322gamester
gangbuster1451962gangbuster
ganger83721472gang__er
ganglier1047602ganglier
gangsta944512gangst_a
gangstas1044402gangstas
ganisters10248312ganisters
gannister1054172gannister
gaster75027352ga__ster
songster935792songster
anger66225883_ang__er
angler74017863_ang_ler
angrier839023_angrier
angst6415503_angst__
angsts738863_angst_s
answer936893_an_swer
antsier7410773_antsier
aster55434893_a__ster
auguster943953_auguster
baluster1037053baluster
banger94423643bang__er
banisher13169183banisher
banisters11189473banisters
bannister1155373bannister
banter84825333ban__ter
baster85333593ba__ster
cadaster1136903cadaster
canistel10187253canistel
canisters112310203canisters
cannister1155723cannister
canter85230113can__ter
caster85232573ca__ster
dabster1036703da_bster
danger83722833dang__er
dangler96912813dang_ler
danglier1056753danglier
daughter1344503daughter
dragster1034633dragster
easter65027983ea__ster
fagoter1135883fa_goter
faster94625773fa__ster
gadgeteer1242413gadgeteer
gager74726293ga_g__er
gagger95016513ga_g_ger
gaiter73819503ga__iter
gamesters1236733gamesters
gander84322763gan__der
gangbusters1561783gangbusters
ganged94619203gang__ed
gangers94418603gang__ers
gangliar1064123gangliar
gangrel996143gang_rel
gangs76222583gangs___
gangsterdom166913gangsterdom
gangsterish1652023gangsterish
gangsterism1552043gangsterism
gangue81310583gang_ue_
gangues9149753gang_ues
gannisters1153843gannisters
gargler93710263garg_ler
garnisher13195853garnisher
garotter965943garotter
garroter956583garroter
garter74420513ga__rter
gasher104320373ga__sher
gasper94515543ga__sper
gasser75017773ga__sser
gassier83812573ga_ssier
gasted84821583ga__sted
gasters85624293ga__sters
gater64533653ga___ter
gauger84714853gaug__er
gaunter82910713ga_unter
ginger84920033ging__er
glister84013343g_lister
granger93514213grang__er
granter84117133gran__ter
grister83915413g_rister
gypster1333953g_ypster
hamster12810423ha_mster
hanger104023263hang__er
hangover15134433hangover
honester1139713honester
jangler153811833jang_ler
janglier1656113janglier
lamister1037653lamister
lamster9109913la_mster
laster64830633la__ster
laughter1245113laughter
magister1136283magister
maltster1035303maltster
manger94325013mang__er
mangier104114063mang_ier
mangler103215643mang_ler
master84831343ma__ster
minister10410363minister
minster93914323min_ster
monster93214603mon_ster
munster93710523mun_ster
nester64124183__nester
paster85734373pa__ster
penster92811953pen_ster
pinaster1037113pinaster
prankster1543183prankster
punster92911103pun_ster
ranger73925533rang__er
rangier83714353rang_ier
ranter63826823ran__ter
raster64731443ra__ster
sanger74524573sang__er
sinister838583sinister
songsters1046113songsters
tangier83013913tang_ier
tangler83515083tang_ler
tanglier948073tanglier
tapster9299273ta_pster
taster64930573ta__ster
tungsten943053tungsten
vanisher14167453vanisher
vaster94521023va__ster
waister103812383wa_ister
wangler113312653wang_ler
wanter94423053wan__ter
waster95228943wa__ster
youngster1341963youngster

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 Filter1786911461620.593301333.9
2DLD Change Limit1461621327.30020022.2
3Display Results1321320.0602200.0
 (SQL Overall)1786911327.95322468.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.