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

115 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
cissoid103734(None) 
cirsoid1038121cirsoid
cissoids1145361cissoids
cestoid104011672cestoid
cystoid13309212cystoid
discoid11311242discoid
histoid1139822histoid
missaid10310302missaid
pissoir945042pissoir
viscoid1337022viscoid
assoil688543_assoil
biosolid1144893biosolid
cactoid12311033cactoid
caisson936593caisso_n
caissons1036283caissons
capsid11312413caps_id
cassia83714763cass_ia
cassis84818853cass_is
cassock1545953cassock
ceboid11310653c_eboid
cessed94615613cess_ed
cession939813cession
cesspit1145463cesspit
cestoi84511953cestoi_
cestoids11308273cestoids
cheloid13310833cheloid
choroid13311803choroid
cichlid1545313cichlid
cisco95112133cisco__
ciscoes113610733ciscoes
ciscos104711133cisco_s
cissies94116153cissies
cissy104811073ciss__y
cisted95217523ci_sted
coccoid11299283coccoid
colloid10312883colloid
conoid9818883c_onoid
cormoid12310403cormoid
cosmid11810643c_osmid
cricoid1239243cricoid
crinoid1039943crinoid
ctenoid1078683ctenoid
cuboid1139503c_uboid
cuspid11429213c_uspid
cussed94917123cuss_ed
cusso74912293cusso__
cussos84210003cusso_s
cussword1443243cussword
cycloid1539283cycloid
cymoid1459473c_ymoid
cystoids14306733cystoids
desmoid1137103desmoid
diploid11310293diploid
discoed11312483discoed
discoids1239873discoids
discord1139993discord
disjoin1547643disjoin
dissed85220183diss_ed
essoin638193_essoin
fibroid1337243fibroid
fission1038733fission
gessoed935743gessoed
gneissoid1151343gneissoid
hispid1238173hi_spid
hissed104114453hiss_ed
issei568573_issei_
isseis638563_isseis
issued746723_issued
jassid1467223jass_id
kissed114412853kiss_ed
lassoed8408743lassoed
lianoid837533lianoid
lipoid9411043li_poid
lissom837403lisso_m
lissome937583lissome
lithoid1148773lithoid
mastoid10711233mastoid
miscoin11311433miscoin
misdid10510573mi_sdid
misjoin1637693misjoin
mislaid1039303mislaid
missed94423603miss_ed
missend104411373missend
misshod1335873misshod
mission9312743mission
missis84417503miss_is
missort9314653missort
missound1145113missound
missout9412663missout
missuit9911303missuit
misword1338413misword
oidioid946053oidioid
pissed94816933piss_ed
pissoirs1044693pissoirs
prismoid1344983prismoid
rissole739783rissole
scincoid1344753scincoid
scission1045563scission
scissor994123scisso_r
scissored1243033scissored
scissors1054353scissors
sciuroid1144403sciuroid
sialoid8310963sialoid
sigmoid1146113sigmoid
simioid1047993simioid
sinusoid944383sinusoid
sistroid947263sistroid
sloid64619713__sloid
tissued835583tissued
viroid10411523vi_roid
virusoid1243183virusoid
viscid1237473vi_scid
wissed104114643wiss_ed
xiphoid2045923xiphoid
zincoid1946663zincoid

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.390458182.1
2DLD Change Limit1340271155.90622693.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.34228175.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.