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

221 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
jassids158614(None) 
jassid1467221jassid_
capsids1239332capsids
cassias93514342cassias
cassis84818852cassi_s
dassies84418662dassies
jasmins1637082jasmins
lassies74420102lassies
lassis65216702lassi_s
masjids17175402masjids
massifs1237742massifs
sassies74719262sassies
tassies74918932tassies
acids87121003_a_cids
aids57846363_a__ids
alcids94812293_alcids
amids85627513_a_mids
aphids125110843_aphids
apsides103911303_apsides
apsis75718293_apsi_s
aroids75118223_aroids
arsis55722423_arsi_s
asdics9439863_asdics
aside65122083_a_side
asides75118873_a_sides
aspics104211563_aspics
aspis74618143_aspi_s
assails769093_assails
assais6711963_assais
assays977903_assays
asses55629283_ass_es
assess65710463_assess
assets65617663_assets
assign736783_assign
assigns836193_assigns
assist6314603_assist
assists738473_assists
assize1538633_assize
assizes1638453_assizes
assoils776663_assoils
avoids104410203_avoids
basics104915123ba_sics
basils85717473ba_sils
basins85722763ba_sins
basis75429863ba_si_s
basses85428303bass_es
bassets96414823bassets
bassi77019323bassi__
bassist9312743bassist
bassists1037183bassists
bassos85313703bass_os
bossies94116833bossies
brassies103613533brassies
caids85226423ca__ids
candids113812693candids
canids95118133ca_nids
capsid11312423capsid_
caseins93115053caseins
cassia83714763cassi_a
cassina94113163cassina
cassinas103610643cassinas
cassine93817283cassine
cassines103116613cassines
cassino93512433cassino
cassinos10309353cassinos
cassises103811743cassises
chassis123910663chassi_s
cissies94116153cissies
cissoids1145373cissoids
classics12418873classics
classis93712723classi_s
cosmids1237633cosmids
cuspids12427113cuspids
daisies84217093daisies
dashis104414393dashi_s
dassie74615573dassi_e
dayside1236173dayside
daysides1335963daysides
desmids1166603desmids
diapsids1244753diapsids
dossils8669773dossils
easies64126633ea_sies
falsies103515013falsies
farside1138603farside
farsides1237993farsides
fascias1258413fascias
fossils10379013fossils
gadids95611823ga_dids
gadoids1036873gadoids
ganoids939333ganoids
gaskins123510773gaskins
gassed85217633gassed_
gassers84714633gassers
gasses75724783gass_es
gassier83812573gassier
gassiest93212523gassiest
gassily1137813gassily
gassing94216333gassing
gassings10438403gassings
glassies94012273glassies
gossips1035903gossips
gussies82813303gussies
halids104016133ha_lids
haloids113012553haloids
hassels104311023hassels
hassium1236133hassium
hassiums1344273hassiums
hassles103411693hassles
hissies103915823hissies
hussies103213293hussies
jackies202912623jackies
jaggies163311083jaggies
jails125422943ja__ils
jammies183611293jammies
jasmin1538073jasmi_n
jasmine1636643jasmine
jasmines1736623jasmines
jaspers164310463jaspers
jaybirds2142823jaybirds
jerids142810943j_erids
jerrids15277743jerrids
jessed144112303jessed_
jesses135215953jess_es
jessing153710623jessing
jesuits1436323jesuits
josses135117683joss_es
jussive1734293jussive
jussives1833843jussives
kamsins1346963kamsins
lashins103915153lashins
lasses64827593lass_es
lassi56316853lassi__
lassie64917743lassi_e
lassoes74613853lassoes
lassos64913813lass_os
maids86327143ma__ids
mantids103113623mantids
mashies12318253mashies
masjid16187323masjid_
massas85116463mass_as
massed94421323massed_
masses85028713mass_es
massier93615223massier
massiest103314423massiest
massif11412533massi_f
massing104318023massing
massive12289773massive
mastics112614783mastics
mastoids1177873mastoids
missies93423983missies
missis84417503missi_s
muscids12187973muscids
musjids17185713musjids
mysids1246563_mysids
nasties73520493nasties
navaids1134803navaids
oasis56422553oa_si_s
palsies94420273palsies
pansies94521983pansies
passade1039233passade
passades1139203passades
passado1037053passado
passados1146303passados
passed94320943passed_
passels93913023passels
passers94717753passers
passes86030473pass_es
passim10410283passi_m
passing104318423passing
passings11409873passings
passion9310883passion
passions10310583passions
passive12239593passive
passives13228823passives
passus83610293pass_us
pasties94529813pasties
pastils94416173pastils
pastis84924323pasti_s
patsies93919483patsies
phasmids16195183phasmids
plasmids13236553plasmids
plastids11269213plastids
pussies93615693pussies
qaids156116313qa__ids
quassias1754933quassias
quassins1735793quassins
raids65827513ra__ids
raisins72715343raisins
ranids75118703ra_nids
rapids94913893ra_pids
rassles73513923rassles
resids74219153_resids
saids65328853__saids
saiyids11174893saiyids
salpids1038193salpids
sasins64923103sa_sins
sassed76116173sassed_
sasses64124393sass_es
sassier73413233sassier
sassiest83413623sassiest
sassily1038723sassily
sassing84615553sassing
sayids104310973sa_yids
sayyids14193833sayyids
sissies73716603sissies
skids104615333__skids
tahsils1035053tahsils
tansies74521243tansies
tarsias74013373tarsias
tassels74510853tassels
tasses64826763tass_es
tassets75012773tassets
tassie66017023tassi_e
tussis6379953tussi_s
ursids737823_ursids
vassals1057953vassals
vespids1334613vespids
wassails1145953wassails
wayside1435183wayside
waysides1544453waysides
wussies103411083wussies

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272217.20318607.1
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.68923239.8
 
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.