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 “printeries” 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
printeries1241067(None) 
grinderies1245852grinderies
pineries102419082p_in_eries
priggeries1444992priggeries
printers103214912printer__s
arteries8321513ar__teries
binderies12311693_binderies
briberies1348343bri_beries
fineries112416753_fin_eries
fripperies1743593fripperies
grilleries1145593grilleries
interims101013073__interims
internes82721233__internes
interties9320343__interties
joineries1648103join_eries
lienteries1047573lienteries
lingeries10511813_lingeries
niteries8318383_ni_teries
orangeries11116943orangeries
painters103013033painter__s
pantries101817393p_ant_ries
papeteries1446563papeteries
perimetries1547783perimetries
peripheries1855003peripheries
piggeries13107893p_iggeries
pointelles1245013pointelles
pointers103013723pointer__s
potteries11313603p_otteries
preinterview2062023preinterview
preinterviews2161323preinterviews
preterites12411803pr_eterites
preterits11410973pr_eterits
primaries13410833pri_maries
princekins1882883princekins
princelier1443343princelier
princeliest1554333princeliest
princesses14206273princesses
prinkers143010393prinker__s
printer93917303printer___
printery13318433printer__y
priories10312453pri__ories
priseres10310823pri_ser_es
pruderies1247873pr_uderies
psalteries1276563psalteries
rifleries1247693_rifleries
shinneries1345723shinneries
spinneries1245733spinneries
sprinters11329373sprinter__s
trickeries1647153trickeries
trinketries15354323trinketries
urinaries949203urin_aries
vineries112716043_vin_eries
wineries112316533_win_eries
winterier1238343_winterier
winteriest1348813_winteriest
winterizes2247143_winterizes

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 Filter1786911406030.423422437.4
2DLD Change Limit140603567.11019775.4
3Display Results56560.0301866.7
 (SQL Overall)178691567.56323627.0
 
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.