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 “journalizer” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
journalizer2716308(None) 
journalize26113941journalize_
journalized28113681journalized
journalizers28121981journalizers
journalizes27103971journalizes
formalizer24257873fo_rmalizer
journaled1742673journal__ed
journalese1752123journalese_
journaleses1852103journaleses
journaling1843173journali_ng
journalism1953873journali_sm
journalisms2053473journalisms
journalist1755003journali_st
journalists1853633journalists
journalizing2953483journalizing
moralizer2049473mo_r_alizer
normalizer21227593no_rmalizer
courtlier1154464cour_tli_er
equalizer2745754equ__alizer
eternalize19118504eternalize_
eternalized21117334eternalized
eternalizes20118174eternalizes
finalizer21307924__finalizer
formalize232710034fo_rmalize_
formalized25268934fo_rmalized
formalizers25255384fo_rmalizers
formalizes242710074fo_rmalizes
jouncier1734424jou_n_ci_er
journal1484964journal____
journalistic2152774journalistic
journals1574354journal___s
journeyer1942024journ__eyer
junglier1644304j_u_ngli_er
localizer20147714lo__calizer
moralize19313924mo_r_alize_
moralized21310754mo_r_alized
moralizers2145844mo_r_alizers
moralizes20312864mo_r_alizes
neutralizer20125784neutralizer
normalize203010104no_rmalize_
normalized22358824no_rmalized
normalizers22214774no_rmalizers
normalizes21259644no_rmalizes
organizer1946754_o_rganizer
pluralize2045774plur_alize_
pluralized2244614plur_alized
pluralizes2165344plur_alizes
realizer172412114___realizer
ruralize1739234_rur_alize_
ruralized1947904_rur_alized
ruralizes1858774_rur_alizes
socializer2146024so_cializer
totalizer1847994to__talizer
tourmaline1243504tourmaline_
tourmalines1343484tourmalines
verbalizer2445994_verbalizer
vernalize2159844_vernalize_
vernalized2348424_vernalized
vernalizes2249324_vernalizes
vocalizer23187574vo__calizer

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819608.45317605.5
3Display Results60600.0302000.0
 (SQL Overall)178691608.90620064.1
 
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.