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

144 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
viscose123786(None) 
viscoses1338341viscoses
ciscoes113610732ciscoes
ciscos104711132ciscos_
discase102912852discase
disclose1148742disclose
discos94915212discos_
dispose10312752dispose
mischose1547252mischose
miscode12310402miscode
piscos105112592piscos_
villose1038052villose
viscoid1337012viscoid
viscous1238832viscous
viscus11428502viscus_
abscise1145953abscise
avisos95410483avis_os_
bioscope1446483bioscope
caseose939163caseose
cirrose937473cirrose
cisco95112133cisco__
diocese1036853diocese
discased122510833discased
discases112014493discases
disclosed1347353disclosed
discloser1256803discloser
discloses1249463discloses
disco85616073disco__
discoed11312473discoed
discoid11311233discoid
discord1139993discord
discourse1246863discourse
discover1439553discover
discs85316263disc_s_
discus94512113discus_
discuses113112843discuses
discuss10357953discuss
disease83213833disease
diseuse83110713diseuse
disposed12310923disposed
disposer11310403disposer
disposes11313793disposes
disrobe1038993disrobe
distome10313233distome
disuse74012833dis_use
disyoke1546233disyoke
episcope1445833episcope
fiascoes13134923fiascoes
fiascos12124743fiascos_
ficoes114613463fi_coes
filose96112503fi_lose
fiscs105311883fisc_s_
fucose11167683_fucose
gibbose1244083gibbose
gismos957183gismos_
glucose1045113glucose
histone10312843histone
impose103113043_impose
incase83615283_incase
incise83515323_incise
inclose9910223_inclose
income10712093_income
incuse83513573_incuse
isodose845373_isodose
jocose1537103_jocose
lissome937583lissome
miscast11312403miscast
mischoose1644393mischoose
mischosen1644003mischosen
miscite11314373miscite
miscoded1437973miscoded
miscodes13310413miscodes
miscoin11311423miscoin
miscook1546473miscook
miscopy1636663miscopy
miscue10412223misc_ue
miscues11312393miscues
misdoes10312493misdoes
misdone10310853misdone
misease92713043misease
mismove1437073mismove
misos76523293mis_os_
mispoise1248243mispoise
misuse83213643mis_use
misyoke1635823misyoke
mucose10149313_mucose
narcose95910383narcose
nicoise937923ni_coise
osmose8108003_osmose
pilose84514233pi_lose
piscine11610973piscine
pisco96314983pisco__
pishoge1336693pishoge
pisos76021063pis_os_
pistole92414313pistole
rescore95616193rescore
ribose839893ri_bose
rimose8310593ri_mose
rissole739783rissole
roscoe839763rosco_e
roscoes9310923roscoes
scone74621833__scone
scope94821483__scope
score75526733__score
scouse84113633__scouse
talcose938133talcose
vadose1037963v_adose
vamoose1235863vamoose
vamose1159283v_amose
varicose1346703varicose
venose9310843v_enose
verbose1237753verbose
vice95732853vi_c__e
vices105725533vi_ces_
vicomte1445723vi_comte
videos104911373videos_
vinasse1044513vinasse
vincas113912453vincas_
vinos84723073vi_nos_
violone1037153violone
vireos94212453vireos_
viroses10310533vi_roses
virtuose1143183virtuose
visage1049083vis_age
visages1138693visages
visas84317653vis_as_
viscera1235083viscera
viscid1237473visc_id
viscosity1744103viscosity
viscount1396783viscount
viscously1744853viscously
vise75632673vi___se
vises84427773vis_es_
visible1236923visible
vision9311313visio_n
visioned1247003visioned
visions10311023visions
visits9311423visits_
visive1257873vis_ive
visor82512833vis_o_r
visored1138143vis_ored
visors92912223vis_ors
vistas94513273vistas_
vitesse1044583vitesse

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.1701051123.5
2DLD Change Limit1340271446.00022337.8
3Display Results1441440.0632285.7
 (SQL Overall)1786911446.23328668.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.