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

82 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
vanishing164630(None) 
banishing1537141banishing
evanishing1743861evanishing
varnishing1744471varnishing
famishing1845232famishing
finishing1645842finishing
garnishing1544572garnishing
lavishing1644552lavishing
minishing1547072minishing
monishing1547542monishing
planishing1645322planishing
punishing1545382punishing
ravishing1634982ravishing
tarnishing1445142tarnishing
vanishingly2151662vanishingly
vanquishing2752282vanquishing
abashing1466623_abashing
agisting1038243_agisting
anguishing1543733_anguishing
anything1534993_anything
arising83619973_aris_ing
ashing107824093_a__shing
bashing135422583ba__shing
blandishing1852903blandishing
brandishing1853353brandishing
burnishing1643913burnishing
cashing135022553ca__shing
dashing125917893da__shing
dishing124017103__dishing
enisling949633_enisling
evanescing1652343evanescing
faithing1537153fa_ithing
fashing144918793fa__shing
fishing143913863__fishing
furnishing1744013furnishing
gashing125119233ga__shing
gnashing1336423_gnashing
hashing145020163ha__shing
ionising9310223ionis_ing
kyanising1743873kyanis_ing
languishing1653113languishing
lashing114422893la__shing
mashing134422243ma__shing
niching133612433__niching
nighing123410063__nighing
nonvanishing1951803nonvanishing
noshing114612773__noshing
panicking1835293panicking
pashing135120513pa__shing
perishing1539533perishing
pishing134314373__pishing
plenishing1644693plenishing
polishing1536923polishing
raising83220533ra_is_ing
ranching141712043ran_ching
relishing13229183relishing
revarnishing1982183revarnishing
sashing114621473sa__shing
squishing2234953squishing
stonishing1444913stonishing
swishing15277813_swishing
unwishing1635593unwishing
vailing113817943va_i_ling
vamosing1435593vamos_ing
vanillin1145903vanillin_
vanillins1245543vanillins
vanish121513203vanish___
vanished15207743vanish_ed
vanisher14167453vanish_er
vanishers15186613vanishers
vanishes141610753vanish_es
vanning113912463van__ning
variating13310933variating
vinifying1944713vinifying
visaing11279333v__isaing
viseing11299163v__iseing
vising103915873v__is_ing
waisting123615213wa_isting
wampishing2142753wampishing
washing145119283wa__shing
whishing18287183_whishing
wishing144114893__wishing

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.1731032896.0
2DLD Change Limit148641828.28317945.3
3Display Results82820.0761078.9
 (SQL Overall)178691828.53220943.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.