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 “idiocy” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
idiocy127346(None) 
dioecy1235542_dioecy
idiom899952idio_m
idioms956412idioms
idiot6718852idio_t
idiots768642idiots
adios65822863adio_s
briony1149043briony
decoy115716313_decoy
deoxy1648883_deoxy
diary95016973_diary
dice75841893_di_ce
dicey114819333_dicey
dick116432383_di_ck
dicky154816243_dicky
dicot85429093_dicot
dicty115116293_dicty
didy99121503_di_dy
dikey135116423_dikey
dilly94923783_dilly
dimly114913483_dimly
dingy105721263_dingy
dinky135819373_dinky
diode74716113_diode
diol57329133_dio_l
diols65521013_diols
dipody1336363dipody
dippy135111543_dippy
dirty95617803_dirty
disc76123233_disc_
disci85815023_disci
disco85616073_disco
discs85316263_discs
dishy125712353_dishy
ditch115015093_ditch
ditsy95612563_ditsy
ditty95019293_ditty
ditzy186513283_ditzy
divvy15356483_divvy
dizzy177410853_dizzy
doby106022163_d_oby
doc66841513_d_oc_
dock116228743_d_ock
docs75631153_d_ocs
dogy96126493_d_ogy
doily95321033_doily
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
dopy106224153_d_opy
dory85836233_d_ory
doty86128223_d_oty
doxy156419953_d_oxy
dozy175920323_d_ozy
edict84722283edi_ct
edify12308563edi_fy
icily101211683ici_ly
icy86322123__i_cy
idiocies1145223idiocies
idiolect1144353idiolect
idiotic1037453idiotic
idiotype1442963idiotype
idly85617323id__ly
idol56818633id_o_l
idols65514133id_ols
iliac75013483iliac_
imbody1434093imbody
incony1139073incony
indict93115563indi_ct
inion54620173inio_n
inions64417003inions
iodic84816743iodi_c_
irony85015903i_rony
ivory1137373i_vory
juicy1738283jui_cy
mediacy1536143mediacy
mincy125817413_mincy
nidify1336763nidi_fy
odic74920573odi_c_
odious749933odious
oidioid946043oidioid
oniony9369703oniony
piddock17103653piddock
pricy124814563pri_cy
priory114110263priory
spicy125417713spi_cy
tidily102811393tidi_ly
vidicon1343783vidicon
zincy195413513_zincy

Search took 9 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 Limit112716907.82614402.8
3Display Results90900.0332727.3
 (SQL Overall)178691908.01522294.6
 
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.