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

54 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
winterize214692(None) 
winterized2345711winterized
winterizes2247141winterizes
winterier1238342winterier
wintering13412362wintering
winterish1546642winterish
wintertide1444462wintertide
wintertime1543812wintertime
bacterize2247673bacterize
cauterize2088323cauterize
dimerize2048113di_merize
fiberize2246143fi_berize
genderize2065673genderize
interage9314493_interage
interfile12411043_interfile
interim9912873_interi_m
interims101013073_interims
interior8513113_interior
interline91218013_interline
interne73218153_inter_ne
internee82718523_internee
intertie8317613_intertie
itemize18106153_i_temize
laterize17613313_laterize
linearize1845753linearize
lingerie959203lingeri_e
niterie7313743ni_teri_e
picturize2244463picturize
pintsize1955103pint_size
sintering101014803sintering
tenderize1976183tenderize
wasterie111211593wasteri_e
weatherize2545843weatherize
westernize2244143westernize
wineries112316533win_eries
winter94222803winter___
wintered122111573winter_ed
winterer112110443winter_er
winterers12209723winterers
winterfed1644993winterfed
winterfeed1743963winterfeed
winteriest1348813winteriest
winterizing2446053winterizing
winterkill1752313winterkill
winterly14306743winter_ly
winters103720483winter__s
wintertides1544473wintertides
wintertimes1643913wintertimes
wintery13399753winter__y
wintrier1136873wint_rier
wintrily1445373wint_rily
wisteria1147773wisteri_a
wisterias1248113wisterias
witherite1546693witherite

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.440406115.9
2DLD Change Limit148641546.98321286.1
3Display Results54540.0163375.0
 (SQL Overall)178691547.43924020.8
 
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.