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

62 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
shavelings174350(None) 
shaveling1646841shaveling_
ravelings13377382_ravelings
shavings15356332shav__ings
shielings13237122sh_ielings
shoveling1635552shoveling_
starvelings1542222starvelings
cagelings1335413_cagelings
changelings1843183changelings
gaveling133410163_gaveling_
graveling1457383graveling_
handlings14237343_handlings
havening15258553_havening_
havering152211053_havering_
heelings12359753_h_eelings
hirelings1365753_hirelings
hoveling15189593_hoveling_
javelinas19353583_javelinas
javelins18277733_javelin_s
leavenings1472583leavenings
panelings12107453_panelings
raveling123414373_raveling_
ravelins113011603_ravelin_s
ravellings14214453_ravellings
ravenings13235183_ravenings
sailings93513253s_a_ilings
samplings1435553s_amplings
sandlings11238093s_andlings
saplings11269803s_a_plings
savings114412953s_av__ings
scantlings1393313scantlings
shackling19286173shackling_
shadings13327433sha__dings
shaftings16224183sha_ftings
shambling1735593shambling_
shapeliness1663163shapeliness
shauling1249393sha_uling_
shaving143414333shav__ing_
shawling1558223sha_wling_
shealings13317563sh_ealings
shearlings1443533shearlings
sheetings13256713sh_eetings
shelvings16283823sh__elvings
shieling123512403sh_ieling_
shillings13348083sh_illings
shivering1637333shivering_
shorelines1346143shorelines
shovelling1744063shovelling_
shriveling1743253shriveling_
silverings1443833silverings
slavering1338723slavering_
sniveling1336033sniveling_
spaeings11276253spa_e_ings
sparlings12257143spa_rlings
stablings12256103sta_blings
starlings10237923sta_rlings
starveling1444263starveling_
surveyings1741973surveyings
swiveling1634573swiveling_
traveling1349053traveling_
whalings15256763wha__lings
wheelings16284933wh_eelings

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603628.92315757.4
3Display Results62620.0601033.3
 (SQL Overall)178691629.13919552.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.