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

75 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
idoliser94504(None) 
idolise839291idolise_
idolised1045671idolised
idolisers1043701idolisers
idolises938761idolises
idolizer1845661idolizer
idolater936862idolater
idolism1037272idolis_m
idolisms1146352idolisms
idolize1737782idolize_
idolized1946002idolized
idolizers1944142idolizers
idolizes1837552idolizes
abolisher1443723abolisher
adonises92611433adonises
adviser11135783ad_viser
atomiser10268153atomiser
deliver113312243_deliver
deviser114212393_deviser
dialyser1243693dialyser
disliker13358643disliker
dopier93515923_dopi_er
dorser74819183_do_rser
doser66228563_do__ser
dosser74417973_do_sser
dossier83711693_dossier
dotier73917033_doti_er
douser75621633_do_user
dowser104716083_do_wser
dozier163611633_dozi_er
foolisher1544223foolisher
godlier938893godli_er
holier94921623_holi_er
idealise938053idealise_
idealised1145673idealised
idealises1047783idealises
idealizer1945473idealizer
idler65015663id_l__er
idolaters1045713idolaters
idolator946243idolator
idolising1145893idolising
idols65514133idol_s__
idylist1146653idylis_t
idylists1244123idylists
incliner1038513incliner
incloser10106733incloser
indorser985713indo_rser
inlier63615363i_nli_er
iodise74214943i_odise_
iodised9329243i_odised
iodises83413633i_odises
iodizer17408663i_odizer
iolite63221983i_olite_
iolites73819483i_olites
ionise63516943i_onise_
ionised82911493i_onised
ionises72916433i_onises
ionizer162310123i_onizer
isoline7314013isoline_
isolines8312303isolines
kiloliter1344013kiloliter
lioniser845583lioniser
midlifer14215793mid_lifer
poiser84217243_po_iser
policer113112683_policer
polisher1388073_polisher
politer92417073_politer
promiser122510673promiser
realiser82512563realiser
sideliner10126013sideliner
solider82912453_solider
stolider936603stolider
styliser11185523styliser
utiliser855243utiliser
woolier103612353wooli_er

Search took 10 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.423422437.4
2DLD Change Limit146162759.45315462.0
3Display Results75750.0302500.0
 (SQL Overall)178691759.90618038.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.