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

157 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
diocese103685(None) 
dioceses1137111dioceses
dices86434242di_ces_
diocesan1142912diocesan
diodes83915782diodes_
discase102912862discase
miocene1147922miocene
adipocere1452133adipocere
bices95029963bi_ces_
biocenose1343543biocenose
biocide1237323biocide
biomes103815253biomes_
daces85030683d_aces_
dances95120653dances_
decease1049523d_ecease
deices94119373deices_
deuces94015513deuces_
dholes104914793dholes_
diabase1037113diabase
dialyse1135463dialyse
dicast9315573di_cast
dice75841893di_c__e
diced95824683di_ce_d
dicer85426423di_ce_r
dicers94720743di_cers
dicey114819333di_ce_y
diciest103316523diciest
dickie133913113di_ckie
dicks125824693di_cks_
dicots94915793dicots_
didies84621833didies_
didoes85716963didoes_
diene65720133di__ene
dienes75719903dienes_
diereses938693diereses
dies55653523di__es_
diesel74410403di__esel
dieses75218693di__eses
diffuse1444373diffuse
digest84019623di_gest
digress938323digress
dikes105831333di_kes_
dimes85833043di_mes_
dimmest1249253dimmest
dimness1038843dimness
dines66449153di_nes_
dinges83825423dinges_
diocesans1242483diocesans
diode74716113dio__de
dioecies1138933dioecies
dioecism1344843dioecism
dioecy1235543dio_ecy
diols65521013dio_ls_
dioptase1145513dioptase
dioptre1055763dioptre
diorite8314913diorite
dioxane1565423dioxane
dioxide1656303dioxide
diphase1387273diphase
dipoles101013753dipoles_
direst75024243di_rest
dirges84915103dirges_
discased122510853discased
discases112014503discases
disced104914653disce_d
discept12310623discept
discern1038493discern
disclose1148743disclose
discos94915213discos_
discrete11410283discrete
discs85316263disc_s_
discus94512113discus_
discuses113112863discuses
discuss10357953discuss
disease83213843disease
diseuse83110723diseuse
dishes104622653dishes_
dismes95617673dismes_
dispense11129783dispense
disperse111011353disperse
dispose10312763dispose
disseise939853disseise
disses75225963disses_
disuse74012843di_suse
ditches133215713ditches_
dites66339153di_tes_
ditzes163212423ditzes_
diureses936453diureses
diverse11429993diverse
dives95832403di_ves_
divest106820073di_vest
divorcee1444673divorce_e
divorcees1543333divorcees
divorces1445673divorces_
divulse1134913divulse
docent92918683d_ocent
docile94213123d_ocile
docks126022313d_ocks_
docs75631153d_oc_s_
does56554473d_o_es_
doest65829523d_o_est
doges75630163d_oges_
doles67843753d_oles_
domes85735563d_omes_
donee66931013d_one_e
donees74519493d_onees
doolee73018953doole_e
doolees83711613doolees
dopes84935043d_opes_
dose56442433d_o__se
doses65938503d_oses_
dotes65836693d_otes_
douse66329723d_o_use
doves94728153d_oves_
dowse96020813d_o_wse
dozes155226303d_ozes_
drones75023433drones_
droves105116673droves_
drowse105010553dro_wse
duces86327473d_uces_
dunces95215753dunces_
eocene8311613_eocene
fices106031163fi_ces_
ficoes114613463ficoes_
ices66129643_i_ces_
idiocies1145223idiocies_
idocrase1183603idocrase
idolise839293idolise
incase83615283_incase
incense92410303_incense
incest82918743_incest
incise83515333_incise
incuse83513573_incuse
iodise74214943_iodise
ionise63516943_ionise
jocose1537103_jocose
license9148423li_cense
lioness739103lioness
lionise7310373lionise
minces104420803minces_
mioses84318853mioses_
nicest82315663ni_cest
nicoise937923nicoise
nieces84112713nieces_
obese75212423__obese
pieces104217273pieces_
pliocene1244593pliocene
process11310403process
rices75536153ri_ces_
siamese936503siamese
sices75637273si_ces_
sincere9310553sincere
vices105725533vi_ces_
viscose1237863viscose
voces105918053_voces_
voices114414013voices_
winces114819113winces_

Search took 8 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.420425454.8
2DLD Change Limit1340271576.89319443.9
3Display Results1571570.0463413.0
 (SQL Overall)1786911577.35924282.0
 
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.