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

55 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
idolisers104370(None) 
idoliser945041idoliser_
idolises938761idolise_s
idolizers1944141idolizers
idolaters1045712idolaters
idolise839292idolise__
idolised1045672idolise_d
idolisms1146352idolis_ms
idolizer1845662idolizer_
idolizes1837552idolize_s
abolishers1543183abolishers
adonises92611433adonise_s
advisers12135003ad_visers
atomisers11255453atomisers
delivers123310753_delivers
devisers12339863_devisers
dialysers1343163dialysers
dislikers14286423dislikers
dorsers83516303_do_rsers
dosers75723633_do__sers
dossers84516233_do_ssers
dossiers9318043_dossiers
dousers84817273_do_users
dowsers115013533_do_wsers
idealises1047783idealise_s
idealizers2043703idealizers
idlers74012813id_l__ers
idolater936863idolater_
idolators1046283idolators
idolising1145893idolising
idolism1037273idolis__m
idolize1737783idolize__
idolized1946003idolize_d
idylists1244123idylis_ts
incliners1146333incliners
inclosers11155563inclosers
indorsers1075383indo_rsers
inliers73110743i_nli_ers
iodises83413633i_odise_s
iodizers18316123i_odizers
iolites73819483i_olite_s
ionises72916433i_onise_s
ionizers17257713i_onizers
isolines8312303isoline_s
kiloliters1442933kiloliters
lionisers944173lionisers
midlifers15254933mid_lifers
poisers94214433_po_isers
policers12259993_policers
polishers1477603_polishers
promisers13268203promisers
realisers9248323realisers
sideliners11125133sideliners
stylisers12204243stylisers
utilisers953553utilisers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641556.26623721.8
3Display Results55550.0301833.3
 (SQL Overall)178691556.71926594.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.