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

111 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
viscoid133702(None) 
discoid11311241discoid
viscid1237471visc_id
cissoid1037342cissoid
discoed11312482discoed
discoids1239872discoids
discord1139992discord
histoid1139822histoid
miscoin11311432miscoin
viroid10411522vi_roid
viscoidal1543172viscoidal
viscose1237862viscose
viscous1238832viscous
zincoid1946662zincoid
abscond1244503abscond
biscuit1147373biscuit
cestoid104011673cestoid
cirsoid1038123cirsoid
cisco95112133cisco__
ciscoes113610733ciscoes
ciscos104711133cisco_s
cissoids1145373cissoids
coccoid11299283coccoid
cricoid1239253cricoid
cystoid13309213cystoid
desmoid1137103desmoid
diacid10310633diac_id
diploid11310293diploid
discard11310213discard
disced104914653disc_ed
disci85815023disc_i_
disco85616073disco__
discoidal1355413discoidal
discoing12511453discoing
discords1238593discords
discos94915213disco_s
disjoin1547643disjoin
ericoid1049893ericoid
fibroid1337253fibroid
fucoid1237893_fucoid
hispid1238173his_pid
inviscid1442303invisc_id
ischia1136393_ischia
lianoid837533lianoid
lipoid9411043li_poid
lithoid1148773lithoid
mastoid10711233mastoid
meniscoid1443313meniscoid
miscode12310413miscode
miscoded1437983miscoded
miscoined1448443miscoined
miscoins12311083miscoins
miscook1546473miscook
miscopied1647173miscopied
miscopy1636663miscopy
miscued1239293miscued
misdid10510573mis_did
misjoin1637693misjoin
mislaid1039303mislaid
missaid10310303missaid
misword1338413misword
mucoid1139783_mucoid
muscid11219833musc_id
oidioid946053oidioid
percoid12312323percoid
pisco96314983pisco__
piscos105112593pisco_s
pissoir945043pissoir
placoid1239773placoid
prismoid1344983prismoid
psocid1137253_psocid
ripcord1264463ripcord
sarcoid10310453sarcoid
scincoid1344753scincoid
scold85414863__scold
sialoid8310963sialoid
sigmoid1146113sigmoid
simioid1047993simioid
sistroid947273sistroid
sloid64619713__sloid
valgoid1255213valgoid
vespid1246083ves_pid
vibrioid1444413vibrioid
viced115118183vi_c_ed
victim1337693vi_ctim
virid94116043vi__rid
viroids1137923vi_roids
virusoid1243183virusoid
visaed104110503vis_aed
visaged1235683visaged
visard103910123vis_ard
viscera1235083viscera
viscidly1753303visc_idly
viscoses1338343viscoses
viscosity1744123viscosity
viscount1396783viscount
viscus11428503visc_us
vised95518763vis__ed
viseed105310983vis_eed
vision9311313visio_n
visioned1247013visioned
visions10311023visions
visit8320963vis__it
visited1168773visited
visor82512833vis_o_r
visored1138143visored
visors92912223vis_ors
vistaed1138023vistaed
vivid125112313vi__vid
void86220573v___oid
xiphoid2045923xiphoid

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 Limit1340271116.64020184.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.