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

327 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
jassid146722(None) 
jassids1586141jassids
bassi77019322bassi_
capsid11312412capsid
cassia83714762cassia
cassis84818852cassis
dassie74615572dassie
gassed85217632gassed
jasmin1538072jasmin
jessed144112302jessed
lassi56316852lassi_
lassie64917742lassie
lassis65216702lassis
masjid16187322masjid
massed94421322massed
massif11412532massif
passed94320942passed
passim10410282passim
sassed76116172sassed
tassie66017022tassie
acid77533393_a_cid
acrid86920103_acrid
aid49269083_a__id
alcid85817973_alcid
algid75415583_algid
amassed10388633amassed
amid77036353_a_mid
aphid115515393_aphid
apsis75718293_apsis
arid57642713_a_rid
aroid65428343_aroid
arsis55722423_arsis
asci66519143_asci_
asdic83814093_asdic
ashed97829773_ashed
aside65122083_a_side
asked106919313_asked
aspic95114733_aspic
aspis74618143_aspis
ass37844063_ass__
assai5711543_assai
assail6610153_assail
assais6711963_assais
assay8710283_assay
asses55629283_asses
asset55932263_asset
assign736783_assign
assist6314603_assist
assize1538633_assize
assoil688543_assoil
astir55517093_astir
avid88325963_a_vid
avoid95516683_avoid
based85331583ba_sed
bashed126225703bashed
basic96220523ba_sic
basil75122273ba_sil
basin75026923ba_sin
basis75429863ba_sis
basked135218603basked
bass66146783bass__
basses85428303basses
basset85225383basset
bassist9312743bassist
bassly114610073bassly
basso76017283bass_o
bassos85313703bassos
bassy1012917103bass_y
basted95227233basted
biassed10418703biassed
bossed94816533bossed
brassed103612373brassed
brassie93411523brassie
bussed94717053bussed
byssi10507993byssi_
caid77837533ca__id
candid104517853candid
canid85526343ca_nid
capsids1239333capsids
cased86032413ca_sed
caseic103212373caseic
casein83216453casein
cashed125124353cashed
casked134815513casked
cassias93514343cassias
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
caused95117043caused
cessed94615613cessed
chassed134712133chassed
chassis123910663chassis
cissoid1037343cissoid
classed104113653classed
classic113710113classic
classis93712723classis
cosmid11810643cosmid
cuspid11429213cuspid
cussed94917123cussed
daisied93410013daisied
dashed115920563dashed
dashi95013113dashi_
dashis104414393dashis
dassies84418663dassies
dayside1236173dayside
desmid1048363desmid
diapsid1146703diapsid
dissed85220183dissed
dossed84516633dossed
dossil75110903dossil
eased65430403ea_sed
falsie93513853falsie
farside1138603farside
fascia1148703fascia
fashed136720253fashed
fasted105320953fasted
fessed104515063fessed
fossil9379353fossil
fussed104613803fussed
gadid85517383ga_did
gadoid9310463gadoid
ganoid8314443ganoid
gashed116321973gashed
gaskin113610583gaskin
gaslit7513503gaslit
gasped104814293gasped
gasser75017773gasser
gasses75724783gasses
gassier83812573gassier
gassily1137813gassily
gassing94216333gassing
gassy95514023gass_y
gasted84821583gasted
gawsie1038463gawsie
glassed93710433glassed
glassie8329493glassie
gossip946433gossip
grassed93812793grassed
gussie72910153gussie
gussied9267193gussied
halid94424983ha_lid
haloid104317763haloid
hashed136021943hashed
hasped125014443hasped
hassel95614213hassel
hassium1236133hassium
hassle93711593hassle
hassled11358303hassled
hasted105125283hasted
hispid1238173hispid
hissed104114453hissed
jabbed184213483jabbed
jabs135830093jabs__
jacked204817523jacked
jaded144417033ja_ded
jadish17319903jadish
jagged164115353jagged
jags126132793jags__
jail115529093ja__il
jailed144917423jailed
jambed184811403jambed
jammed183811503jammed
jams135231073jams__
japed156217633ja_ped
jarred144613253jarred
jars117338353jars__
jasmine1636643jasmine
jasmins1637083jasmins
jasper154610383jasper
jauked18489013jauked
jauped16457903jauped
jawed165517373ja_wed
jaws145027293jaws__
jaybird2043123jaybird
jays146328343jays__
jazzed22416293jazzed
jerid132316423j_erid
jerrid14259143jerrid
jess116022033jess__
jesse126012833jess_e
jesses135215953jesses
jessing153710623jessing
jested144416503jested
jesuit1339583jesuit
joshed174610903joshed
joss115925593joss__
josses135117683josses
jurassic1742993jurassic
jussive1734293jussive
justed144215773justed
kamsin1238323kamsin
kissed114412853kissed
laid56439143la__id
lapsed94712583lapsed
lased65132343la_sed
lashed105625213lashed
lass47444543lass__
lasses64827593lasses
lassies74420103lassies
lasso55015683lass_o
lassoed8408743lassoed
lassos64913813lassos
lasted74323603lasted
maid75537663ma__id
mantid93820383mantid
mashed125325043mashed
mashie11315933mashie
masjids17175403masjids
masked134316523masked
mass66044943mass__
massa75518923mass_a
massas85116463massas
masse75125293mass_e
masses85028713masses
massier93615223massier
massifs1237743massifs
massing104318023massing
massive12289773massive
massy104518963mass_y
masted94025803masted
mastic103119173mastic
mastix152310513mastix
mastoid10711233mastoid
messed95018183messed
misdid10510573misdid
missaid10310303missaid
missed94423603missed
missis84417503missis
mossed94818893mossed
muscid11219833muscid
musjid16216953musjid
mussed94418903mussed
mysid11610693_mysid
nastic82915973nastic
navaid1037653navaid
naysaid1145313naysaid
oasis56422553oa_sis
ossia53710403_ossia
paid75737483pa__id
pallid93915283pallid
palsied102911303palsied
parsed96323893parsed
pashed125923143pashed
pass65239953pass__
passade1039233passade
passado1037053passado
passe75525693pass_e
passee84522023passee
passel85117003passel
passer84721033passer
passes86030473passes
passing104318423passing
passion9310883passion
passive12239593passive
passus83610293passus
pasted94426903pasted
pastie85525523pastie
pastil85018323pastil
pastis84924323pastis
paused95114963paused
pavid115717003pa_vid
phasmid15267603phasmid
pissed94816933pissed
plasmid12239553plasmid
plastid102112523plastid
qaid146023843qa__id
quassia1644793quassia
quassin1645943quassin
rabid84520783ra_bid
raid55243073ra__id
raised76120333raised
raisin62716923raisin
rancid9513863rancid
ranid66429333ra_nid
rapid86422033ra_pid
rased65033933ra_sed
rasped94715203rasped
rassle63813203rassle
rassled83310453rassled
resaid74517083resaid
resid64124093_resid
said55742113__said
saiyid10167413saiyid
salpid9510883salpid
sapid84720933sa_pid
sashed105622943sashed
sasin54626573sa_sin
sass45035623sass__
sasses64124393sasses
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
sassy85813813sass_y
sayid95516723sa_yid
sayyid13185353sayyid
skid95720933__skid
slid55828983__slid
sussed75015533sussed
tabid84418263ta_bid
tahsil936343tahsil
tarsi55222173tarsi_
tarsia65514273tarsia
tasked114714643tasked
tass45640573tass__
tasse54821843tass_e
tassel66014773tassel
tasses64826763tasses
tasset65925313tasset
tassies74918933tassies
tasted74123973tasted
tawsed10499743tawsed
tossed74215223tossed
tussis6379953tussis
unsaid7411833unsaid
ursid6311483_ursid
valid94618393va_lid
vapid115614283va_pid
vassal979243vassal
vespid1246083vespid
viscid1237473viscid
washed135521503washed
wassail1056133wassail
wasted104423023wasted
wayside1435183wayside
wissed104114643wissed
yessed104511163yessed

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163275.47020606.2
3Display Results3273270.1102972.7
 (SQL Overall)1786913275.95330017.0
 
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.