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

80 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
shamoying184452(None) 
shammying2042951shammying
chammying2243352chammying
shadowing1744262shadowing
shambling1735592shambling
shaming133016742sham__ing
shamming16289412sham_ming
shampooing1843092shampooing
shimmying2042532shimmying
chamoising1855163chamoising
champing183610933cham_ping
clamoring1477423clamoring
enamoring1247033enamoring
haloing113814133_halo_ing
hamboning1745893_hamboning
hamming153014093_ham_ming
harrying15157643_harrying
haying134420613_ha__ying
humoring1456853_humoring
sallying12309853s_allying
sambaing1337113s_ambaing
sampling13510643s_ampling
savoring1269483s_avoring
savvying1862723s_avvying
saying104325543s_a__ying
scamming15328543scam_ming
scamping153510193scam_ping
seagoing1038193seago_ing
seaming103222113seam__ing
seasoning1037413seasoning
shacking184014083sha_cking
shackling19286173shackling
shading123115563sha__ding
shafting15278683sha_fting
shagging14349053sha_gging
shaking153317253sha__king
shallowing1744113shallowing
shamois123210423shamo_i_s
shamosim1544753shamosi_m
shamoy14379913shamoy___
shamoyed1744043shamoy_ed
shamoys15367283shamoy__s
shanking163612283sha_nking
shaping133116183sha__ping
sharing113723243sha__ring
sharking163912973sha_rking
sharping143011373sha_rping
shauling1249393sha_uling
shaveling1646843shaveling
shaving143414333sha__ving
shawing143514883sha__wing
shawling1558223sha_wling
shimming16278253shim_ming
shinnying16193723shinnying
shmoozing2443613shmoozing
shoeing113211883sh__oeing
shooing112112913sh__ooing
shooling123012563sh_ooling
shooting122812863sh_ooting
shoring112820073sh__oring
shoving142910643sh__oving
showing143814663sh__owing
shying134211843sh___ying
sjamboking2641933sjamboking
slaloming1244743slaloming
slamming133310003slam_ming
slaying113316843sla__ying
smoking143210523s__moking
spamming15317603spam_ming
spaying133014623spa__ying
stamping133310963stam_ping
staying114017323sta__ying
stimying1437503stim_ying
stroying122410593s_troying
stymying1733963stym_ying
summoning14115693summoning
swamping16307923swam_ping
swaying143610643swa__ying
vamosing1435593_vamosing
whamming19275223wham_ming

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.423422437.4
2DLD Change Limit148641806.26623721.8
3Display Results80800.0302666.7
 (SQL Overall)178691806.71926594.9
 
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.