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

233 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
dioecy123554(None) 
dicey114819332dice_y
dikey135116422dike_y
direct93817332direct
direly10311552direly
idiocy1273462idio_cy
biogeny1336023biogeny
biopsy1334533biopsy
biotech14104493biotech
bisect10312873bisect
cicely1338833cicely
cooey105828223cooe_y
decay114718483d__ecay
decency1537453decency
deck115827753d__eck
deco76125973d__eco
decoy115716313d__ecoy
decry115514353d__ecry
deedy104315893d_eedy
defect124816173defect
defy114921263d__efy
deject164512843deject
demy105422853d__emy
deny86027123d__eny
deoxy1648883deo_xy
detect94217403detect
dewy115419023d__ewy
dexy156118553d__exy
dey77243373d__e_y
dhooly13457143dhooly
dialect101210263dialect
diarchy1644673diarchy
diary95016973di_ary
dice75841893di__ce
diced95824683dice_d
dicer85426423dice_r
dicers94720743dicers
dices86434243dice_s
dick116432383di__ck
dickey165913523dickey
dicky154816243di_cky
dicty115116293di_cty
dicycly1843273dicycly
didact10711203didact
diddly12389573diddly
didoes85716963didoe_s
didy99121503di__dy
die46759653di_e__
died66137853di_e_d
diel59034603di_e_l
diene65720133di_ene
dieoff1335503dieoff
dies55653523di_e_s
diet57357533di_e_t
diets66026643di_ets
digamy1335883digamy
digest84019623digest
dike95935763dike__
diked115024683dike_d
diker105524553dike_r
dikers114418793dikers
dikes105831333dike_s
dilly94923783di_lly
dime76237643dime__
dimer85625603dime_r
dimers94321093dimers
dimes85833043dime_s
dimity12310473dimity
dimly114913483di_mly
dimply14339743dimply
dine55555333dine__
dined76431993dine_d
diner65632903dine_r
dinero75612643dinero
diners75525953diners
dines66449153dine_s
dingey114914053dingey
dinghy14476963dinghy
dingy105721263di_ngy
dinkey144812763dinkey
dinkly144311083dinkly
dinky135819373di_nky
diobol936883diobol
diocese1036853diocese
diode74716113dio_de
diodes83915783diodes
dioecies1138933dioecies
dioecism1344843dioecism
diol57329133dio__l
diols65521013dio_ls
dioxan1465773dioxan
dioxid1568393dioxid
dioxin14118783dioxin
dipody1336363dipody
dippy135111543di_ppy
dire56644143dire__
directly1455303directly
directs102710263directs
direr64927073dire_r
direst75024243direst
dirty95617803di_rty
disc76123233di_sc_
disced104914653disced
disci85815023di_sci
disco85616073di_sco
discs85316263di_scs
diseur738843diseur
dishy125712353di_shy
disject17268673disject
dismay12229473dismay
disobey1346243disobey
dissect103614133dissect
ditch115015093di_tch
dite55547553dite__
dites66339153dite_s
dithery14318943dithery
ditsy95612563di_tsy
ditty95019293di_tty
ditzy186513283di_tzy
dive85634773dive__
dived106321373dive_d
diver94827803dive_r
divers105024963divers
divert103922813divert
dives95832403dive_s
divest106820073divest
divorce1344813divorce
divvy15356483di_vvy
dizen155214933dize_n
dizens164911393dizens
dizzy177410853di_zzy
dobby136013633d_obby
doby106022163d_o_by
doc66841513d_o_c_
dock116228743d_o_ck
docs75631153d_o_cs
dodgy116611463d_odgy
doe47361953d_oe__
doer57734703d_oe_r
doers65225713d_oers
does56554473d_oe_s
doest65829523d_oest
doeth9411983d_oeth
dogey105719513d_ogey
doggy115214873d_oggy
dogy96126493d_o_gy
doily95321033d_oily
dolce85816683d_olce
dolci84912603d_olci
dolly96125203d_olly
donsy96414683d_onsy
doody105517913d_oody
dooly94821803d_ooly
doomy116018263d_oomy
doozy186813713d_oozy
dopey116020353d_opey
dopy106224153d_o_py
dorky135518743d_orky
dormy115817463d_ormy
dorty96220813d_orty
dory85836233d_o_ry
dotty94516103d_otty
doty86128223d_o_ty
douce85518423d_ouce
dowdy136112543d_owdy
dowery134311663dowery
downy125714553d_owny
dowry126312483d_owry
doxy156419953d_o_xy
doyly124514013d_oyly
dozy175920323d_o_zy
dreck124812803d_reck
drecky16486333d_recky
drolly105411673drolly
drooly104911073drooly
droopy12458243droopy
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drowsy13487903drowsy
dupery12378743dupery
dweeby1542993dweeby
dykey16608673dyke_y
fiery114714793fi_ery
finely123011563finely
finery124512893finery
fleecy14266483fleecy
gooey95522863gooe_y
hooey114926603hooe_y
icy86322123_i__cy
idiolect1144353idiolect
jivey185111873jive_y
joey145719333_joe_y
likely13328133likely
limey104721043lime_y
lineny94011443lineny
liney87029633line_y
lively123310813lively
livery124910903livery
looey84822913looe_y
mincy125817413mi_ncy
misery114113543misery
moiety1148223moiety
monoecy1445083monoecy
nicely1139493nicely
nicety1138433nicety
niece74814503ni_ece
ninety9510963ninety
nitery94412173nitery
piece96717993pi_ece
piety105817303pi_ety
pinery115214293pinery
piney105727503pine_y
piracy1339473piracy
poesy105014063_poesy
rifely123710033rifely
riley84420583rile_y
ripely112511153ripely
sinewy12667513sinewy
sooey84522433sooe_y
timely113410113timely
viewy14518103vi_ewy
vilely1239443vilely
vinery124912603vinery
widely133311033widely
wifely15429423wifely
wifey144913673wife_y
wincey144110383wincey
winery125014283winery
winey115325433wine_y
wisely122711713wisely
zincy195413513zi_ncy
zooey173914803zooe_y

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162336.07618551.0
3Display Results2332330.0802912.5
 (SQL Overall)1786912336.31228309.7
 
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.