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 “shantung” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
shantung123274(None) 
shantungs1341651shantungs
chanting143413532chanting
hanting114124482_hanting
scanting113914762scanting
shafting15278682shafting
shanking163612282shanking
shunting123610432shunting
slanting94115092slanting
anting75827023__anting
banteng1046363_banteng
canting104725903_canting
chancing162810283chancing
changing153211513changing
charting142614193charting
chatting142810143chatting
chaunting1555413chaunting
granting103514523granting
hafting144014173_hafting
halting114419073_halting
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
hasting114725193_hasting
hating104929713_ha_ting
hatting113920233_hatting
haunting123510053_haunting
henting113719653_henting
hinting113919223_hinting
hunting114317123_hunting
panting104025423_panting
planting113515383planting
quanting1849233quanting
quantong1843493quantong
ranting84025413_ranting
sainting93215733sainting
salting84120793s_alting
sanding93520603s_anding
saning75127643s_an_ing
santur6311273s_antu_r
santurs7310763s_anturs
satang75711563s_a_tang
sating74735453s_a_ting
scanning113310773scanning
scantling12107233scantling
scarting113415263scarting
scatting113311813scatting
scenting113212813scenting
seating84130683sea_ting
shacking184014083shacking
shading123115563sha_ding
shaftings16224183shaftings
shagging14349053shagging
shaitan1036893shaitan_
shaitans1136413shaitans
shaking153317253sha_king
shaming133016743sha_ming
shamming16289413shamming
shanny124110093shan__ny
shantey134210043shant_ey
shanteys14395513shanteys
shanti94014093shant__i
shanties113116593shanties
shantih13309643shant_ih
shantihs14276213shantihs
shantis103313103shant_is
shanty124715123shant__y
shaping133116183sha_ping
sharing113723243sha_ring
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sha_ving
shawing143514883sha_wing
shawling1558223shawling
sheeting122712833sheeting
shending132511253shending
shifting152910383shifting
shining113816523shin_ing
shinning123211023shinning
shirting123213613shirting
shitting123212663shitting
shooting122812863shooting
shorting122514803shorting
shotting123012383shotting
shouting122711793shouting
shunning12367843shunning
shuting113212053sh_uting
shutting12309693shutting
skanking12288743skanking
skating123613853ska_ting
slanging103413433slanging
slating83724653sla_ting
slatting94014233slatting
smarting113212453smarting
spanking153911973spanking
spanning113311083spanning
spatting113111763spatting
standing103413633standing
stanging104013653stanging
staning83922243stan_ing
starting93116173starting
stating83725163sta_ting
stinting93415743stinting
stung65417153s___tung
stunting92811503stunting
swanking16399963swanking
swanning12338813swanning
swatting12309593swatting
thanking16409523thanking
wanting114220173_wanting
whanging16267143whanging

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621127.66019081.2
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.17221866.3
 
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.