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

84 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
idolised104567(None) 
idolise839291idolise_
idoliser945041idoliser
idolises938761idolises
idolized1946001idolized
idealised1145672idealised
idolisers1043702idolisers
idolism1037272idolis_m
idolisms1146352idolisms
idolize1737782idolize_
idolizer1845662idolizer
idolizes1837552idolizes
iodised9329242i_odised
ionised82911492i_onised
abolished1544273abolished
adonises92611433adonises
advised12136043ad_vised
agonised10248483agonised
atomised11278833atomised
azotised1844443azotised
civilised1584613civilised
creolised1255203creolised
delimed11310723_delimed
delisted10310563_delisted
demised113613683_demised
devised123712563_devised
dialysed1344413dialysed
disliked14288553disliked
doiled84817293_do_iled
doited85016633_do_ited
doled75430913_dol__ed
dolled83518073_dol_led
dollied93811143_dollied
dosed76626913_do__sed
dossed84516633_do_ssed
doused84821163_do_used
dowsed115015013_do_wsed
ebonised1136043ebonised
finalised13338013finalised
folioed1138033_folioed
hoised105117433_ho_ised
idealise938053idealise_
idealises1047783idealises
idealized2046653idealized
idled74915213id_l__ed
idolater936863idolater
idolising1145893idolising
idolizers1944143idolizers
idols65514133idol_s__
idylist1146653idylis_t
idylists1244123idylists
implied1238623impli_ed
incised102911583i_ncised
inclined1138643inclined
inclosed1197613inclosed
indorsed1066123indo_rsed
iodise74214943i_odise_
iodises83413633i_odises
iodized18969163i_odized
iolite63221983i_olite_
iolites73819483i_olites
ionise63516943i_onise_
ionises72916433i_onises
ionized172611293i_onized
irised73913153i__rised
ironized1858203ironized
isolated9410523isolated
isoline7314013isoline_
isolines8312303isolines
itemised11105163itemised
lionised946603lionised
noised75416233_no_ised
obelised1136173obelised
odorized1945843odorized
ozonised1853893ozonised
poised94918473_po_ised
policed123212233_policed
polished1468433_polished
promised133010873promised
realised92214533realised
sidelined11125883sidelined
stylised12215893stylised
utilised956733utilised
vitalised1347203vitalised

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.406440125.6
2DLD Change Limit146162847.25020160.3
3Display Results84840.0302800.0
 (SQL Overall)178691847.68623248.9
 
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.