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

52 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
oidioid94605(None) 
opioid9310082o_pioid
simioid1047992simioid
android9311513android
cardioid1247453cardioid
cirsoid1038123cirsoid
cissoid1037343cissoid
dioxid1568393__dioxid
diploid11310293diploid
discoid11311243discoid
droid74218543__droid
fibroid1337243fibroid
gadoid9310463gad_oid
gobioid1146023gobioid
histoid1139823histoid
hydroid1539713hydroid
idiocy1273463_idiocy
idiom899963_idio_m
idioms956413_idioms
idiot6718863_idio_t
idiotic1037463_idiotic
idiots768643_idiots
indigoid1143873indigoid
iodid74315533iod__id
iodised9329243iodised
iodized18969163iodized
kidvid1535023kid_vid
lianoid837533lianoid
lipoid9411043li_poid
lithoid1148773lithoid
nidified1346763nidified
obovoid1342783obovoid
oceloid1037973oceloid
ochroid1357903ochroid
odious749933o_dious
ogdoad943523ogd_oad
oidia6314953oid__ia
oidium959813oidi_um
opioids1036523o_pioids
osteoid848193osteoid
ovoid94811023o__void
oxidised1743413oxidised
oxidized2644033oxidized
radioed939673radioed
sialoid8310963sialoid
sigmoid1146113sigmoid
tidied83613273tidi_ed
vibrioid1444403vibrioid
viroid10411523vi_roid
viscoid1337023viscoid
xiphoid2045923xiphoid
zincoid1946663zincoid

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.390458182.1
2DLD Change Limit134027526.19021652.2
3Display Results52520.0134000.0
 (SQL Overall)178691526.59327103.1
 
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.