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

205 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
strunting103787(None) 
strutting1037001strutting
stunting92811501st_unting
grunting10269582_grunting
shunting123610432s_hunting
sprinting12310032sprinting
stinting93415742st_inting
stounding1136232stounding
stranding1149652stranding
striating10914192striating
stringing1139752stringing
strumming1454412strumming
stunning9298462st_unning
taunting93510932_taunting
truanting1035602_truanting
trusting93411652_trusting
amounting1236643amounting
astounding1244153astounding
astricting1357833astricting
astringing1245773astringing
attuning935903attun_ing
blunting11319843_blunting
bruiting11259973_bruiting
bruting102612993_bru_ting
bunting103718833__bunting
chaunting1555413chaunting
counting113115273_counting
crusting113612793_crusting
daunting103310403_daunting
destructing1546113destructing
distrusting1386503distrusting
dunting93418383__dunting
entrusting11126183entrusting
eructing112110173_eructing
erupting11218443_erupting
estranging1246023estranging
estreating11710363estreating
flaunting1335043flaunting
fronting12310443_fronting
fruiting12229063_fruiting
granting103514523_granting
gruntling1134263_gruntling
haunting123510053_haunting
hunting114317123__hunting
instructing1446293instructing
intrusting11128173intrusting
irrupting1243553irrupting
jaunting16328633_jaunting
lunting83817743__lunting
mistrusting1465923mistrusting
mounting112711813_mounting
munting103718773__munting
obstructing1644573obstructing
outhunting1446143outhunting
outrunning1145683outrunning
parenting12611583parenting
pothunting1643653pothunting
printing113216083_printing
pruning10311733_prun_ing
punting103318443__punting
ranting84025413__ranting
renting84026853__renting
rerenting102617663rerenting
rerunning1036523rerunning
running83514593__running
rusting83821263__rusting
rutting82718043__rutting
sainting93215733s_ainting
saluting9310553salu_ting
saturating11119203saturating
saunaing937013s_aunaing
scanting113914763s_canting
scenting113212813s_centing
scouting112612753scou_ting
scripting1437473scripting
scrounging1443353scrounging
scrubbing1633933scrubbing
scrumming1654023scrumming
scrunching18163473scrunching
scrupling1435193scrupling
scrutiny1344773scru_tiny
seriating10916403seriating
serrating10513213serrating
shouting122711793shou_ting
shrining122610853shrin_ing
shrinking1735653shrinking
shrugging1533703shrugging
shunning12367843s_hunning
shuting113212053s_hu_ting
shutting12309693s_hutting
sinuating1039683sinuating
siruping1136503siru_ping
situating1038883situating
sklenting1475123sklenting
skunking12256653s_kunking
slanting94115093s_lanting
smutting11278063s_mutting
snouting92511923snou_ting
sorning83116813sor_n_ing
sorting83221813sor__ting
sounding102712873s_ounding
splinting1238193splinting
spouting113511953spou_ting
springing1338743springing
sprouting1236943sprouting
sprucing1336893spru_cing
spunking15258063s_punking
spurning11258663spurn_ing
spurting113111633s_purting
squinting1936223squinting
stagnating1254973stagnating
staining9413373stain_ing
standing103413633st_anding
stanging104013653st_anging
staning83922243st_an_ing
starting93116173st_arting
stating83725163st__ating
staunching1643213staunching
stetting93410713st_etting
stilting93312403st_ilting
stinging103213453st_inging
stinking133113543st_inking
stoning83717443st_on_ing
stotting92811163st_otting
strafing122111193str_afing
straining10410563straining
strangling1256403strangling
strapping1436993strapping
strawing122411623str_awing
straying122912693str_aying
streaking142010323streaking
streaming12239653streaming
streeking14217453streeking
streeling10189483streeling
stressing1038333stressing
strewing12289853str_ewing
striding102713603str_iding
striking133012233str_iking
string75327563str___ing
stringings1245233stringings
striping112612523str_iping
stripling1257783stripling
stripping1436493stripping
striving122611393str_iving
stroking132610943str_oking
strolling10238793strolling
strontia845873stronti_a
strontian944473strontian
strontians1043783strontians
strontias945623strontias
strontic1048123stronti_c
strontium1144633strontium
stropping1436933stropping
strouding1136373strouding
strowing122310563str_owing
stroying122410593str_oying
structuring1453173structuring
struggling1342503struggling
strung75213023stru___ng
strunt64918913strunt___
strunted957243strunt_ed
strunts7429543strunt__s
stubbing13237453st_ubbing
studding1136703st_udding
studying1335553st_udying
stuffing15247843st_uffing
stumming13347673st_umming
stumping13289083st_umping
suiting83419003s__uiting
sunning83715673s__unning
surmounting1442643surmounting
swounding1434133swounding
swouning12246563swoun_ing
syringing1435883syringing
syruping1434253syru_ping
tainting93613583_tainting
tauting83316383_tau_ting
tenting84621153_t_enting
thrusting1335013thrusting
thunking16196953_thunking
tinting84620603_t_inting
touting84118453_tou_ting
trancing112812023_trancing
treating92519613_treating
trending103012833_trending
trining82919213_trin_ing
trotting92510913_trotting
trouncing1235153_trouncing
trucing103211843_tru_cing
trucking153310163_trucking
trudging11266443_trudging
trueing83410183_tru_eing
truing73913933_tru__ing
trumping13308733_trumping
truncating1344233_truncating
trundling1135003_trundling
trussing9268653_trussing
trysting12267053_trysting
tufting11289873_t_ufting
tuning74016843_t_un_ing
tunning83514453_t_unning
turning83713183_turn_ing
tutting83515913_t_utting
untrusting1186003untrusting
vaunting12338753_vaunting

Search took 8 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.420425454.8
2DLD Change Limit1486412056.97021325.8
3Display Results2052050.0932204.3
 (SQL Overall)1786912057.48323879.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.