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

89 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
famishing184523(None) 
banishing1537142banishing
faithing1537152fa_ithing
fashing144918792fa__shing
finishing1645842finishing
fishing143913862f__ishing
flemishing1943492flemishing
lavishing1644552lavishing
ravishing1634982ravishing
vanishing1646302vanishing
wampishing2142752wampishing
abashing1466623_abashing
agisting1038243_agisting
amassing1138003_amassing
ambushing1744033_ambushing
amusing1039383_amus_ing
arising83619973_aris_ing
ashing107824093_a__shing
bashing135422583ba__shing
bemisting1438073bemisting
blemishing1843513blemishing
cashing135022553ca__shing
damasking1744603damasking
dashing125917893da__shing
demising122012523demis_ing
dishing124017103__dishing
enmeshing15114873enmeshing
evanishing1743863evanishing
failing113521333fa_i_ling
fainting123312163fa_inting
fairing113614013fa_i_ring
faming124922973fam___ing
famish14311843famish___
famished1766023famish_ed
famishes1658283famish_es
famishment2054543famishment
farthing1538073fa_rthing
fasting114522833fa__sting
fatiguing1443053fatiguing
fishings15307693f__ishings
fisting113818123f__isting
flashing153711553f_lashing
fleishig1542893fleishi_g
fleshing15339303f_leshing
flushing15288833f_lushing
foisting122910503f_oisting
freshing152611023f_reshing
frisking16268363f_risking
furbishing1943373furbishing
furnishing1744013furnishing
garnishing1544573garnishing
gashing125119233ga__shing
hashing145020163ha__shing
immeshing17103463immeshing
inmeshing1595333inmeshing
lashing114422893la__shing
mashing134422243__mashing
meshing134513813__meshing
miching152911803__miching
minishing1547073minishing
missing103619073__missing
misting103623383__misting
monishing1547543monishing
moshing134214883__moshing
mushing134217633__mushing
pashing135120513pa__shing
perishing1539533perishing
pishing134314373__pishing
planishing1645323planishing
polishing1536923polishing
punishing1545383punishing
raising83220533ra_is_ing
ramifying1855603ramifying
relishing13229183relishing
remising112516453remis_ing
sashing114621473sa__shing
smashing143310243_smashing
smushing14287453_smushing
squishing2234953squishing
swishing15277813_swishing
tarnishing1445153tarnishing
unmeshing1595933unmeshing
unwishing1635593unwishing
vamosing1435593vamos_ing
varnishing1744473varnishing
waisting123615213wa_isting
washing145119283wa__shing
whishing18287183_whishing
wishing144114893__wishing

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 Filter1786911486410.466383457.1
2DLD Change Limit148641896.28323657.6
3Display Results89890.0302966.7
 (SQL Overall)178691896.77926359.5
 
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.