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

156 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
discoid1131124(None) 
discoed11312481discoed
discoids1239871discoids
discord1139991discord
viscoid1337021viscoid
cissoid1037342cissoid
desmoid1137102desmoid
diacid10310632diac_id
diploid11310292diploid
discard11310212discard
disced104914652disc_ed
disci85815022disc_i_
disco85616072disco__
discoidal1355412discoidal
discoing12511452discoing
discords1238592discords
discos94915212disco_s
disjoin1547642disjoin
histoid1139822histoid
miscoin11311432miscoin
viscid1237472visc_id
zincoid1946662zincoid
abscond1244503abscond
biscuit1147373biscuit
cestoid104011673cestoid
cirsoid1038123cirsoid
cisco95112133cisco__
ciscoes113610733ciscoes
ciscos104711133cisco_s
cissoids1145363cissoids
coccoid11299283coccoid
cricoid1239243cricoid
cystoid13309213cystoid
dacoit9415453d_acoit
deltoid938573deltoid
dentoid9310663dentoid
dermoid1138523dermoid
descend11248153descend
descried1248073descried
desmid1048363des_mid
desmoids1244973desmoids
despoil1046523despoil
despond1137513despond
devoid1189363d_evoid
diacids1137863diac_ids
diamond1186113diamond
diapsid1146703diapsid
diced95824683di_c_ed
dicked144920863di_cked
dickie133913113di_ckie
dicot85429093di_co_t
dicots94915793di_cots
dioxid1568393di_oxid
diploic1247763diploic
diploids1247843diploids
diploidy1544733diploidy
disaccord1552623disaccord
disband1138243disband
disbound1245853disbound
disbud10165713dis_bud
disc76123233disc___
discant103017263discant
discards1238913discards
discase102912863discase
discased122510853discased
discept12310623discept
discern1038493discern
discing113914593discing
disclaim1345643disclaim
disclike15208653disclike
disclose1148743disclose
disclosed1347363disclosed
discolor1146423discolor
discomfit1754683discomfit
discorded1438133discorded
discount11811313discount
discover1439563discover
discrown1445283discrown
discs85316263disc__s
discus94512113disc_us
discuss10357953discuss
disdain938513disdain
dished114318713dis_hed
disjoined1845833disjoined
disjoins1647623disjoins
disjoint1649233disjoint
disked125015763dis_ked
disomic1238763disomic
disown1036953dis_own
dispend11289413dispend
disport101015953disport
dispose10312763dispose
disposed12310943disposed
disrobe1038993disrobe
disrobed1238093disrobed
disroot8413563disroot
dissed85220183dis_sed
distain8313783distain
distend93312073distend
distil73616433dis_til
distome10313233distome
distort81120333distort
disulfid13144243disulfid
disused93211033disused
disyoke1546233disyoke
disyoked1745463disyoked
ditched143711903ditched
dittoed936733dittoed
droid74218543d__roid
ericoid1049893ericoid
fibroid1337243fibroid
fucoid1237893_fucoid
hispid1238173his_pid
ischia1136393_ischia
lianoid837533lianoid
lipoid9411043li_poid
lithoid1148773lithoid
mastoid10711233mastoid
meniscoid1443313meniscoid
miscode12310413miscode
miscoded1437983miscoded
miscoined1448443miscoined
miscoins12311083miscoins
miscook1546473miscook
miscopied1647163miscopied
miscopy1636663miscopy
miscued1239293miscued
misdid10510573mis_did
misjoin1637693misjoin
mislaid1039303mislaid
missaid10310303missaid
misword1338413misword
mucoid1139783_mucoid
muscid11219833musc_id
oidioid946053oidioid
percoid12312313percoid
pisco96314983pisco__
piscos105112593pisco_s
pissoir945043pissoir
placoid1239773placoid
prismoid1344983prismoid
psocid1137253_psocid
ripcord1264463ripcord
sarcoid10310453sarcoid
scincoid1344753scincoid
scold85414863__scold
sialoid8310963sialoid
sigmoid1146113sigmoid
simioid1047993simioid
sistroid947263sistroid
sloid64619713__sloid
viroid10411523vi_roid
viscoidal1543173viscoidal
viscose1237863viscose
viscous1238833viscous
xiphoid2045923xiphoid

Search took 7 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 Limit1340271566.11021935.7
3Display Results1561560.0463391.3
 (SQL Overall)1786911566.56227231.2
 
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.