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

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

77 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
imides9451533(None) 
amides95722661amides
imide85716871imide_
imids86015121imid_s
imines84918341imines
irides74519121irides
abides94719892abides
aides65336602_aides
amices105018012amices
amide86128472amide_
amids85627502amid_s
amies76837682ami_es
amines84727982amines
asides75118872asides
azides165113802azides
bides85536772_bides
brides94423512brides
chides124620472chides
cimices13279802cimices
diamides1238802diamides
divides123211452divides
elides74420692elides
emydes1236172emydes
glides84518862glides
grides84422362grides
guides84118282guides
hides95129422_hides
ibices10398152ibices
ibidem1134782ibidem
ibises83610532ibises
ides57734232__ides
images91411452images
imbeds11456722imbeds
imbibes1334672imbibes
imbues1037962imbues
imid76122272imid__
imidic11358192imidic
imido85812222imid_o
imine75821042imine_
immies102412422immies
immixes1835062immixes
impedes124310092impedes
indies73822772indies
insides8512652insides
iodides93811612iodides
irades74517392irades
irids66417762irid_s
irises64221172irises
ivies84215752ivi_es
limites92915452limites
lipides103810622lipides
midges103516472_midges
midis85923402_midis
mids76541772_mid_s
mikes115129892_mikes
miles74645072_miles
mimes95732022_mimes
mines75651952_mines
mires75640882_mires
mises74740562_mises
mites75141802_mites
mixes147224402_mixes
modes85537412_modes
nides65229132_nides
oxides14109692oxides
prides94324182prides
rides66140812_rides
sides65838362_sides
similes92915232similes
slides73922182slides
smidges11448192smidges
smiles84522292smiles
smites83921922smites
tides64830152_tides
timider1037092timider
timidest1136932timidest
wides94832822_wides

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit82551772.73630172.1
3Display Results77770.0135923.1
 (SQL Overall)178691772.85562588.8
 
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.