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

104 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
ebonised113604(None) 
ebonise939611ebonise_
ebonises1039221ebonises
ebonized2036971ebonized
agonised10248482agonised
demonised1348232demonised
ebonies9312882eboni_es
ebonite9310292ebonite_
ebonites1039232ebonites
ebonize1838152ebonize_
ebonizes1938072ebonizes
ionised82911492_ionised
lionised946602lionised
ozonised1853892ozonised
abolished1544273abolished
abscised1364133abscised
adonises92611433adonises
agonise83112693agonise_
agonises92613163agonises
agonized19258993agonized
atomised11278833atomised
azotised1844443azotised
banished14189063_banished
bodied103814583_bodi_ed
boiled95020953_bo_iled
boinked14457043_boinked
bonded104719953_bon_ded
boned85133243_bon__ed
boneset9316433_boneset
bonged105719603_bon_ged
bonier84321993_boni_er
boniest93318993_boniest
bonked135517313_bon_ked
bonuses94212953_bonuses
bossed94816533_bo_ssed
botanised1246393_botanised
boused95322883_bo_used
bowsed125715973_bo_wsed
braised104014803_braised
bruised10389503_bruised
canonised1256713canonised
cognised1256313cognised
colonised12248723colonised
deboned113411633debon__ed
debruised1343003debruised
deionized2057153deionized
demonise11411933demonise_
demonises12311093demonises
demonized2239853demonized
ebonics1137193eboni_cs
ebonising1245933ebonising
ebons74316093ebon_s__
economised1544203economised
elegised10145923elegised
eloined8149813elo_ined
embodied1445293embodi_ed
embossed1344693embo_ssed
enisled82510223e__nisled
enosises8311003enosises
eonism83213533e_onis_m
eonisms92811043e_onisms
epoxied1734813epoxi_ed
erotized1838553erotized
eternised10116273eternised
eulogised1143733eulogised
evanished1644323evanished
excised1736673e_xcised
exorcised1944353exorcised
feminised15226953feminised
hoised105117433_ho_ised
honied104818393_honi_ed
idolised1045673idolised
iodised9329243_iodised
ionise63516943_ionise_
ionises72916433_ionises
ionized172611293_ionized
ironized1858203ironized
jonesed1536263_jonesed
kyanised16214163kyanised
lionise7310373lionise_
lioniser845583lioniser
lionises8310313lionises
lionized1837023lionized
melodised1345043melodised
memorised14118223memorised
monied94319463_moni_ed
monished1438133_monished
nebulised1243733nebulised
noised75416233_no_ised
obelised1136173obelised
ozonise1646443ozonise_
ozonises1776373ozonises
ozonized1745113ozonized
phonied133710563phoni_ed
poised94918473_po_ised
ponied94920703_poni_ed
promised133010873promised
rebodied1237243rebodi_ed
reboiled11349393rebo_iled
recognised1444123recognised
stonished1345593stonished
tetanised1096513tetanised
unionised1046533unionised
urbanised1295123urbanised

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621046.34323043.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.82926166.5
 
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.