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

49 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
whereases154567(None) 
phereses1348092phere_ses
whereas13448902wherea__s
aphereses1466423aphere_ses
bereaves1338263_bereaves
boreases10310253_boreases
cereuses1049243_cereuses
charases131312753char_ases
cheeses123613103che_e_ses
creases94020963__creases
deceases11410153_deceases
decreases1237223decreases
degreases1146153degreases
diereses938693diere_ses
erases64425403__er_ases
gheraoes1244813gher_aoes
greases84816713__greases
heiresses1236963_heiresses
herbages1437083_herbages
heredes11313133_here_des
heresies11312693_heresies
increases1157383increases
peeresses1138453peeresses
permeases1347093_permeases
pheresis1377633phere_sis
phrases12711463ph_r_ases
precreases1445653precreases
releases8313343_releases
rheobases1443203rheobases
seeresses939053seeresses
sherrises12156863sherrises
terrases82111453_terrases
thermoses1447973thermoses
ureases74416723__ureases
waenesses1239773waenesses
wharfages1942633wharfages
wheedles1534643whe_edles
wheelbases1872383wheelbases
wheelies1437863whe_elies
wheeples1634743whe_eples
wheezes22306803whe_e_zes
whereat134311923wherea__t
wherefores1983393wherefores
wheres125917433wher___es
wherever1743823where_ver
wherries14179023wher_ries
wherves16548053wher__ves
wheyfaces2351523wheyfaces
woenesses1239133woenesses

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 Filter1786911486410.186960704.3
2DLD Change Limit148641498.83016833.6
3Display Results49490.0301633.3
 (SQL Overall)178691499.04619753.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.