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

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

41 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
weatherproofs246177(None) 
weatherproof2362041weatherproof_
waterproofs1953012w_at_erproofs
weatherproofed2671342weatherproofed
waterproof1853533w_at_erproof_
weatherpersons2271603weatherpersons
weatherproofing2771163weatherproofing
leatherwoods1952454leather_woods
shatterproof2061234shatterproof_
waterproofed21142344w_at_erproofed
waterproofer20182504w_at_erproofer
waterproofers21151994w_at_erproofers
wearproof1753034wea___rproof_
weathercocks2661804weather_cocks
weatherperson2161744weatherperso_n
airproofs1443355__a__irproofs
fatherhoods2153035_father_hoods
featherbrains21132245featherbrains
flameproofs2161545fla_me_proofs
greaseproofs1871015grea_se_proofs
heatproof1753825heat___proof_
leatherwood1852725leather_woo_d
mothproofs2052155_moth__proofs
tamperproof2061215_tamperproof_
waterfloods18152765w_at_erfloods
waterfronts1752695w_at_erfronts
waterloos1246045w_at_er_loo_s
waterproofing2261995w_at_erproofing
waterproofings2371325w_at_erproofings
waterproofness227945w_at_erproofness
waterzoois2253525w_at_er_zoois
weatherboard2152965weather_board
weatherboards2262605weatherboards
weathercasts20252505weather_casts
weathercock2561825weathe__rcock
weatherglass1961585weather_glass
weatherings1895265weathe__rings
weatherizes2645945weathe__rizes
weathers143412835weathe__r___s
weatherworn2052615weathe__rworn
wetproof1643765we_t___proof_

Search took 10 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 Filter1786911247900.376475242.0
2DLD Change Limit124790419.29613424.1
3Display Results41410.0301366.7
 (SQL Overall)178691419.70218418.0
 
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.