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

56 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
winterizes224714(None) 
winterize2146921winterize_
winterized2345711winterized
wineries112316532win_eri_es
winterier1238332winteri_er
winteriest1348812winteri_est
wintertides1544462wintertides
wintertimes1643902wintertimes
bacterizes2347963bacterizes
binderies12311683binderi_es
cauterizes2197993cauterizes
dimerizes2167943di_merizes
fiberizes2346173fi_berizes
fineries112416743fin_eri_es
genderizes2176003genderizes
interfiles1349993_interfiles
interims101013073_interi_ms
interiors9513563_interiors
interlines101116453_interlines
intermixes1948393_intermixes
internees93014843_internees
internes82721233_inter_nes
interties9320333_interties
itemizes19106023_i_temizes
laterizes18513013_laterizes
lienteries1047563lienteri_es
linearizes1945733linearizes
lingeries10511813lingeri_es
niteries8318383ni_teri_es
picturizes2344563picturizes
pineries102419083pin_eri_es
printeries12410633printeri_es
tenderizes2076673tenderizes
vineries112716043vin_eri_es
wasteries121115343wasteri_es
weatherizes2645943weatherizes
westernizes2344123westernizes
wiggeries14136573wiggeri_es
wintered122111573winter__ed
winterer112110443winter__er
winterers12209723winter_ers
winterfed1644993winter_fed
winterfeed1743963winterfeed
winterfeeds1852623winterfeeds
wintering13412363winteri_ng
winterish1546643winteri_sh
winterizing2446053winterizing
winterkills1851923winterkills
winters103720483winter___s
wintertide1444453wintertide_
wintertime1543813wintertime_
wintrier1136873wint_ri_er
wintriest1238153wint_ri_est
wintriness1345543wint_riness
wisterias1248103wisteri_as
witherites1645973witherites

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 Filter1786911406030.420425454.8
2DLD Change Limit140603565.86023993.7
3Display Results56560.0331697.0
 (SQL Overall)178691566.31328305.2
 
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.