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 “idealizer” 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
idealizer194547(None) 
idealize1847871idealize_
idealized2046651idealized
idealizers2043701idealizers
idealizes1947391idealizes
idealise938052idealise_
idealised1145672idealised
idealises1047782idealises
idolizer1845662id_olizer
realizer172412112_realizer
alkalizer22155563alkalizer
deadlier1036863_deadli_er
dealer74122143_deal__er
decaliter1247983_decaliter
decliner113710843_decliner
dekaliter1445063_dekaliter
deliver113312243_de_liver
dialyzer2143113_dialyzer
dualize1759763_dualize_
dualized1937403_dualized
dualizes1838823_dualizes
equalizer2745753equalizer
finalizer21307923finalizer
idealism1147013ideali_sm
idealisms1246443idealisms
idealist9310653ideali_st
idealists1047223idealists
idealities1148783idealities
ideality1247153ideali_ty
idealizing2147293idealizing
ideative1238573ideative_
idoliser945043id_oliser
idolize1737783id_olize_
idolized1946003id_olized
idolizers1944143id_olizers
idolizes1837553id_olizes
itemizer19104453ite_mizer
legalizer1946323legalizer
liberalizer2244523liberalizer
localizer20147713localizer
mealier93015903_meali_er
mineralizer2245303mineralizer
moralizer2049473moralizer
pedalier1137603pedali_er
realiser82512563_realiser
realize162717083_realize_
realized182514223_realized
realizers18237933_realizers
realizes173116843_realizes
sideliner10126013side_liner
totalizer1847993totalizer
vealier102712173_veali_er
visualizer2263853visualizer
vitalizer2147303vitalizer
vocalizer23187573vocalizer

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 Filter1786911486410.423422437.4
2DLD Change Limit148641557.43619989.4
3Display Results55550.0163437.5
 (SQL Overall)178691557.87522690.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.