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

230 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
viscid123747(None) 
viscoid1337021viscoid
diacid10310632diacid
disced104914652disced
disci85815022disci_
discoid11311242discoid
hispid1238172hispid
inviscid1442302inviscid
misdid10510572misdid
muscid11219832muscid
vespid1246082vespid
viced115118182vi_ced
virid94116042vi_rid
viroid10411522viroid
visaed104110502visaed
visard103910122visard
viscidly1753302viscidly
viscus11428502viscus
vised95518762vis_ed
viseed105310982viseed
visit8320962vis_it
vivid125112312vi_vid
acid77533393__acid
aisled74516183aisled
alcid85817973_alcid
asci66519143_asci_
bifid11910703bi_fid
biocide1237323biocide
biscuit1147373biscuit
cirsoid1038123cirsoid
cisco95112133cisc_o
ciscos104711133ciscos
cissoid1037343cissoid
cisted95217523cisted
coccid102910743coccid
cosmid11810643cosmid
cuspid11429213cuspid
desmid1048363desmid
diacids1137863diacids
diced95824683di_ced
dioxid1568393dioxid
disbud10165713disbud
disc76123233disc__
discard11310213discard
discing113914593discing
disco85616073disc_o
discoed11312483discoed
discoids1239873discoids
discord1139993discord
discos94915213discos
discs85316263disc_s
discus94512113discus
dished114318713dished
disked125015763disked
dissed85220183dissed
distil73616433distil
episcia1145123episcia
evinced1335403evinced
exscind1743753exscind
fascia1148703fascia
ficin103516723fi_cin
fisc96819753fisc__
fiscal1139333fiscal
fiscs105311883fisc_s
fished134316313fished
fisted104218703fisted
fistic11812573fistic
hissed104114453hissed
histed104420243histed
histoid1139823histoid
iced78721893_i_ced
imid76122293_i_mid
iodid74315533_iodid
irid55927173_i_rid
ischia1136393_ischia
isled64615993_isled
jassid1467223jassid
kidvid1535023kidvid
kissed114412853kissed
licit74327683li_cit
limpid11389753limpid
lipid85916173li_pid
lipoid9411043lipoid
liquid1637143liquid
lisped94113423lisped
listed74322833listed
livid96714423li_vid
lucid84314573_lucid
masjid16187323masjid
minced114114913minced
misadd1037163misadd
misaim10311853misaim
misbind1258273misbind
miscite11314383miscite
miscited13310423miscited
miscode12310413miscode
miscoin11311433miscoin
miscue10412223miscue
miscued1239293miscued
miscut10614813miscut
misfed124113023misfed
misfit112813833misfit
mishit112618193mishit
mislaid1039303mislaid
misled94719313misled
mislie83219153mislie
mislit83019693mislit
missaid10310303missaid
missed94423603missed
missis84417503missis
misted93625823misted
mucid104115253_mucid
muscids12187973muscids
musjid16216953musjid
mysid11610693mys_id
niacin8310223niacin
nicad8312613ni_cad
nisei54214353nisei_
niseis63512023niseis
nisi45823243nis_i_
nitid61817833ni_tid
nitrid72812233nitrid
ovicide1346433ovi_cide
pieced113912103pieced
piscina1177043piscina
piscine11610973piscine
pisco96314983pisc_o
piscos105112593piscos
pished124817063pished
pissed94816933pissed
pistil83915073pistil
placid114012543placid
psocid1137253psocid
rancid9513863rancid
resaid74517083resaid
rescind10410393rescind
resid64124093res_id
riced85825543ri_ced
ricin74620213ri_cin
rigid7913893ri_gid
rishi8311253rishi_
rishis9312453rishis
risked115514633risked
said55742113__said
scad75725773__scad
scud76221283__scud
sialid7314943sialid
sicced11489653sicced
siskin1079783siskin
skid95720923__skid
slid55828983__slid
ticced11438443ticced
timid84815733ti_mid
tineid74412023tineid
triacid1038593triacid
unsaid7411833unsaid
ursid6311483urs_id
valid94618393v_alid
vapid115614283v_apid
verbid122311313verbid
vesica11157913vesica
vespids1334613vespids
vested104217353vested
vialed105112593vialed
viand9511073vi_and
viatic11311453viatic
vibrio1136223vibrio
vicar10513863vi_car
vice95732853vi_c_e
vices105725533vi_ces
vichy1639043vi_chy
vicing124014243vi_cing
victim1337693victim
vid77241803v___id
vied86328633vi__ed
viewed1345993viewed
vigia94813273vi_gia
vigil94313003vi_gil
villi86517853villi_
vinca105315163vinc_a
vincas113912453vincas
vined95626153vi_ned
vinic10314973vi_nic
violin9311983violin
virgin1038083virgin
viricide1446423viricide
viroids1137923viroids
virucide1443593virucide
virusoid1243183virusoid
vis66747613vis___
visa76323873vis__a
visage1049083visage
visaged1235683visaged
visaing11279333visaing
visards11328153visards
visas84317653vis_as
viscera1235083viscera
viscidity1843873viscidity
viscoidal1543173viscoidal
viscose1237863viscose
viscous1238833viscous
vise75632673vis__e
viseing11299163viseing
vises84427773vis_es
vising103915873vising
vision9311313vision
visited1168773visited
visits9311423visits
visive1257873visive
visor82512833vis_or
visored1138143visored
visors92912223visors
vista85416603vis_ta
vistaed1138023vistaed
vistas94513273vistas
visual938803visual
vitric112510113vitric
vizard19458853vizard
vizir17359393vi_zir
voiced123910113voiced
void86220563v__oid
winced124415343winced
wised95123343wis_ed
wished134417513wished
wisped123411893wisped
wissed104114643wissed
wisted104120273wisted
zinced18419413zinced
zincic1935903zincic
zincoid1946663zincoid

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.1231452772.4
2DLD Change Limit1127162305.06322262.7
3Display Results2302300.0802875.0
 (SQL Overall)1786912305.26633933.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.