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

178 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
gossips103590(None) 
gossip946431gossip_
gossipy1343951gossipy
bossies94116832bossies
dossils8669772dossils
fossils10379012fossils
glossies93311252glossies
godships1544722godships
gossans836782gossans
gossiped1263512gossiped
gossiper1164202gossiper
gossipers1263542gossipers
gossipry1441902gossipry
gussies82813302gussies
tossups964022tossups
bosses85925403boss_es
bossier93712423bossier
bossiest103112213bossiest
bossily1237563bossily
bossing103714603bossing
bossism1136063bossism
bossisms1244703bossisms
cassias93514343cassias
cassis84818853cassi_s
cissies94116153cissies
cosies84932153co_sies
cosmids1237633cosmids
cossets95014283cossets
cousins9516003cousins
cowslips1543613cowslips
dassies84418663dassies
dossals8379293dossals
dossels85511603dossels
dossers84516233dossers
dosses76126273doss_es
dossier83711693dossier
dossiers9318043dossiers
dossil75110903dossi_l
dossing93313273dossing
eosins64419163eo_sins
flossies112810123flossies
fossas94610703foss_as
fosses96022083foss_es
fossick16134733fossick
fossicks17134163fossicks
fossil9379353fossi_l
gaskins123510773gaskins
gasps85415483g_as_ps
gassers84714633gassers
gasses75724783gass_es
gassier83812573gassier
gassiest93212523gassiest
gassily1137813gassily
gassing94216333gassing
gassings10438403gassings
genips9469943g_enips
gessoes838293gessoes
gips75632923g___ips
gipsies1039903gipsies
glassies94012273glassies
glossas8438193gloss_as
glossers9319053glossers
glosses84014123gloss_es
glossier9358203glossier
glossiest10277943glossiest
glossily1235093glossily
glossina9275543glossina
glossinas10214143glossinas
glossing10278883glossing
glossitis10143593glossitis
gnosis75711213gnosi_s
gnostics1146323gnostics
goalies8316023goalies
gobies95418063go_bies
goblins1039243goblins
godship1445083godship_
godsons966663godsons
godwits1234133godwits
gonifs104310133go_nifs
goodies93516993goodies
goonies83618333goonies
goops86620963go__ops
gooses75723053goos_es
goosier83512563goosier
goosiest92911823goosiest
goosing93314083goosing
gorps85316993go__rps
gorses74723293gors_es
gorsier83811073gorsier
gorsiest92511133gorsiest
gosling93312403gosling
goslings10297553goslings
gospels1035593gospels
gossan747233goss_an
gossiping1353213gossiping
gossipped1552323gossipped
gossipper1472593gossipper
gossippers1552203gossippers
gossipries1352433gossipries
gossoon865663gossoon
gossoons944893gossoons
gossypol1451473gossypol
gossypols1551453gossypols
gothics1336123gothics
grasps9489253gras_ps
grips85520133g__rips
grossers94410973grossers
grosses84517683gross_es
grossing103111063grossing
gunships1445173gunships
gussets837443gussets
gussie72910153gussi_e
gussied9267193gussied
gypsies1335953gypsies
hissies103915823hissies
hussies103213293hussies
hyssops1543123hyssops
jassids1586143jassids
josses135117683joss_es
lassies74420103lassies
lassis65216703lassi_s
losses65925233loss_es
massifs1237743massifs
missies93423983missies
missis84417503missi_s
mosaics1138073mosaics
mossers94116193mossers
mosses85527683moss_es
mossier94413813mossier
mossiest103112443mossiest
mossing103915423mossing
noesis6311443noesi_s
oasis56422553_oasi_s
opsins8411713_opsins
osmics1036463_osmics
osseins736133_osseins
ossia53710403_ossi_a
ossify1244973_ossify
oxlips1544433_oxlips
poesies93217403poesies
popsies112816463popsies
posies84431433po_sies
posits85718713po_sits
posses85128803poss_es
possess9419123possess
possets94212773possets
possums1145753possums
posties93128813posties
postins93721203postins
postops11311713postops
potsies93019483potsies
poussies1038113poussies
prossies101515223prossies
pussies93615693pussies
reships1239863reships
rosehips1344253rosehips
roshis9311793roshi_s
rosins64521863ro_sins
sassies74719263sassies
ships105123773__ships
sips65740103___sips
sissies73716603sissies
skips115616603__skips
slips76023723__slips
snips75818013__snips
sonships1357463sonships
tassies74918933tassies
tocsins939963tocsins
tonsils7310183tonsils
tossers74713503tossers
tosses65225393toss_es
tossing83612563tossing
tossup875293tossup_
tussis6379953tussi_s
unships1237203unships
worships1647103worships
wussies103411083wussies
zoysias1943843zoysias

Search took 9 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.296603685.8
2DLD Change Limit1340271788.31316122.6
3Display Results1781780.1261412.7
 (SQL Overall)1786911788.73520456.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.