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

40 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
feasances144540(None) 
feasance1345821feasance_
defeasances1752282defeasances
pleasances1444192pleasances
adamances1445033adamances
balances1279973_balances
bechances1847613bechances
brisances1345843brisances
clearances1444793clearances
defeasance1652543defeasance_
defiances1557033defiances
deviances1566493deviances
enhances1339293_enhances
essences1047563_essences
faiences1337043f_aiences
fasces114914543f_as__ces
feases95422923feas___es
fences114617113fe___nces
fiances12310673f__iances
finances1338653f_inances
flagrances1644183flagrances
fleabanes1443553fleaban_es
fragrances1643883fragrances
freelances1545223freelances
malfeasances1961423malfeasances
misfeasances1961893misfeasances
nonfeasances1752853nonfeasances
nuisances1145333nuisances
obeisances1443993obeisances
peasants1038263peasan_ts
penances12312443pe_nances
pleasance1344303pleasance_
reactances1446143reactances
rebalances1445253rebalances
reliances1139623reliances
seances93015343se__ances
tendances1247573tendances
usances967373__usances
valances1398763_valances
weasands1244563weasan_ds

Search took 9 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.423422437.4
2DLD Change Limit148641407.65619415.0
3Display Results40400.0301333.3
 (SQL Overall)178691408.10922036.1
 
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.