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

43 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
oinomels104451(None) 
oenomels1044581oenomels
oinomel946351oinomel_
ionomers1038502ionomers
oenomel946562oenomel_
agnomens1144893agnomens
benomyls1542983benomyls
binocles1236413binocles
binomials1343903binomials
biomes103815253bi_ome_s
calomels1236133calomels
cognomens1443863cognomens
enamels9128163_enamels
genomes103611703genome_s
gimels938893gi__mels
gnomes93812973_gnome_s
incomers1268593_incomers
incomes11712373_income_s
ionogens956823ionogens
ionomer939833ionome_r
ionones7313883ionone_s
isohels1035393_isohels
isomers9310043_isomers
lintels73311163lin_tels
minimals12327433minimals
misnomers1346183misnomers
monomers12311033monomers
noels56418703__no_els
noisomely1442843noisomely
nomes74933123__nome_s
nonnovels1243443nonnovels
novels95512503__novels
ointment1069233ointment
ointments1166653ointments
oligomers1243533oligomers
philomels1643503philomels
pinocles1248693pinocles
pinoles93418703pinole_s
pinones94717073pinone_s
tinsels738373tin_sels
venomers1336703venomers
winoes94317013wino_e_s
winsomely1743193winsomely

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 Filter1786911461620.420425454.8
2DLD Change Limit146162437.29620033.2
3Display Results43430.0162687.5
 (SQL Overall)178691437.73223110.6
 
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.