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

143 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
dubious103689(None) 
rubious938281rubious
cubitus11346782cubitus
curious93813562curious
devious1138522devious
dubiously1545292dubiously
durions839962durions
duteous838452duteous
furious103110632furious
nubilous1044852nubilous
aduncous1143163aduncous
anxious1437283anxious
audios72312283audio_s
aurous64119263au_rous
bijous1548043__bijous
bilious9310933bilious
biogs85016113__biogs
bios66335333__bio_s
boubous1138693boub_ous
buboes104513993bub_oes
bubus95115453bub__us
bulbous1138293bulbous
bullous9311663bullous
bunions92210473bunions
burnous938823burnous
carious93320283carious
cautious103110233cautious
copious11311963copious
cubics123810163cubi_cs
cubisms13306883cubisms
cubists11359023cubists
cubits103714033cubi_ts
cuboids1236723cuboids
cumbrous1446173cumbrous
cuprous1149743cuprous
curios83218333curio_s
danios7314603danio_s
debits94214503debi_ts
debtors1038533debtors
desirous947783desirous
diecious1146873diecious
dioicous1145133dioicous
diols65521013d__iols
dobies94422093dobi_es
doblons1037043doblons
dobros93910233dobro_s
dobsons1036203dobsons
dubbers124011823dubbers
dubbings14245473dubbings
dubbins12358803dubbins
dubiety1344593dubiety
dubnium1244183dubnium
dubniums1343153dubniums
dubs78432193dub___s
dufus94010813du__fus
dugout8310363du_gout
dugouts935043du_gouts
duits65021883du_i_ts
dulias71212743duli_as
dumbos114111083dumbo_s
dunites8313593dunites
duologs935363duologs
duomos936823duomo_s
duos56728133du__o_s
durians839573durians
durion7510963durio_n
durocs9569703du_rocs
duros65422693du_ro_s
duties74921903duti_es
dutiful1144763dutiful
edacious1146023edacious
envious1037223envious
euripus934623euripus
fibrous1237593fibrous
folious103710733folious
fucous11399863fu_cous
fugios1037583fugio_s
fulvous1334543fulvous
fungous11367433fungous
fuscous1256673fuscous
fusions1039153fusions
gabions102410053gabions
gibbous1265333gibbous
gummous1236263gummous
habitus12338173habitus
hugeous1137133hugeous
impious1137063impious
jabirus1694573jabirus
jubiles16289373jubiles
juniors1475783juniors
lubricous1343953lubricous
luminous1037113luminous
lupous849433lu_pous
luscious1044853luscious
luteous739273luteous
mucinous1245373mucinous
mucous104411653mu_cous
muticous1246933muticous
mutinous1047653mutinous
nimious937663nimious
noxious1446563noxious
nubias8310093nubi_as
numinous1046293numinous
obvious1244823obvious
odious749933_odious
osmious936003osmious
pious74621273__pious
pluvious1344443pluvious
pubis94616473pubi__s
pulpous1177013pulpous
qubits173710353qubi_ts
quipus17458003qu_ipus
rubies84420343rubi_es
rubigos1033653rubigos
rubout8313563rub_out
rubouts937983rub_outs
rubus76415063rub__us
ructious10277083ructious
rufous948273ru_fous
rugous739653ru_gous
ruinous739763ruinous
sanious7514103sanious
scabious1246593scabious
serious73616283serious
simious939803simious
spurious1036963spurious
studious9245553studious
suberous10311803suberous
sublots92410913sublots
subvirus1344333subvirus
tedious838443tedious
tuberous1047503tuberous
tubings10336483tubings
tubists9288323tubists
tubulous1045383tubulous
turions7311573turions
ubique1784883_ubique
unions64216753_unions
urinous7310083_urinous
usurious845273usurious
uveous936603_uveous
various103113103various
vicious1239493vicious

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 Limit1340271435.78023188.1
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.24928595.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.