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

269 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
striating1091419(None) 
seriating10916401seriating
astricting1357832astricting
estreating11710362estreating
lariating10311792lariating
patriating13510202patriating
satiating10311812satiating
scripting1437472scripting
serrating10513212serrating
sprinting12310032sprinting
stating83725162st__ating
stilting93312402st_ilting
stinting93415742st_inting
strafing122111192str_afing
straining10410562straining
strawing122411622str_awing
straying122912692str_aying
streaking142010322streaking
streaming12239652streaming
striation9313482striation
striations10312792striations
striding102713602stri_ding
striking133012232stri_king
stringing1139752stringing
striping112612522stri_ping
stripling1257782stripling
stripping1436492stripping
striving122611392stri_ving
strunting1037872strunting
strutting1037002strutting
treating92519612_treating
triaging102610542_triaging
variating13310952variating
abstricting1654503abstricting
aerating92821003aer_ating
aspirating1348363aspirating
astringing1245773astringing
attriting1048693attri_ting
attritting1144763attritting
aviating12311033_aviating
berating113220763ber_ating
borating113414503bor_ating
castrating1349773castr_ating
crating103725203_cr_ating
creating113921953_creating
curating11314293cur_ating
derating103222283der_ating
deviating14311093deviating
districting1559013districting
drifting13338733_drifting
elutriating1245073elutriating
entreating11811553entreating
estating92614993est__ating
estimating1348883estimating
estivating1447633estivating
estraying1338293estr_aying
expiating1938543expiating
extricating2146693extricating
filiating1339253filiating
foliating1339253foliating
fritting123510703_fritting
furcating1537783furcating
grating93923183_gr_ating
grifting13299263_grifting
gritting10309983_gritting
gyrating1337453gyr_ating
herniating1445983herniating
intreating11614013intreating
irrigating1245953irrigating
irritating1146293irritating
iterating10314253iterating
lustrating1147783lustr_ating
marinating13410273marinating
mediating13311203mediating
meriting11314693meri_ting
metricating1647363metricating
mistreating1449283mistreating
narrating10310353narrating
nitrating10312673nitr_ating
obviating1545063obviating
opiating11410093_opiating
orating83520323_or_ating
outrating10916403outr_ating
pirating11314513pir_ating
prating103424453_pr_ating
printing113216083_printing
radiating111112133radiating
rating74938703__r_ating
restricting1449303restricting
retreating111414773retreating
rifting113515003__rifting
rioting82716393__rioting
sainting93215733s_ainting
salivating1447443salivating
sanitating1149653sanitating
sating74735453s___ating
saturating11119203saturating
scraping133310863scr_aping
screaking16228243screaking
screaming14217833screaming
scribing13238183scri_bing
scrieving1534133scrieving
scrimping1634953scrimping
scriving14258763scri_ving
seating84130683s__eating
sedating103014113s_edating
sensating1039253sensating
seriatim1049223seriati_m
seriation9318063seriation
seriations10316683seriations
shifting152910383s_hifting
shirting123213613s_hirting
shitting123212663s_hitting
shrieking1734583shrieking
shrieving1633973shrieving
shrilling13307693shrilling
shrimping1734063shrimping
shrining122610853shri_ning
shrinking1735653shrinking
shriving15268453shri_ving
sibilating1346973sibilating
sifting113014593s__ifting
silting83320483s__ilting
sinuating1039683sinuating
siting74126623s__i_ting
sitting83519633s__itting
situating1038883situating
skating123613853s__kating
skirting13289393s_kirting
skiting123812503s_ki_ting
slating83724653s__lating
slitting93012583s_litting
smiting103014443s_mi_ting
solating9315593s_olating
solvating1336443solvating
sonicating1348313sonicating
sopiting11310763sopi_ting
sorting83221813sor__ting
speciating1548123speciating
spiraling1237953spiraling
spiriting1238413spiriting
spirting112913633s_pirting
spiting103917623s_pi_ting
spitting113012323s_pitting
splinting1238193splinting
splitting1236563splitting
spoliating1366963spoliating
spraining1248153spraining
spraying14299883spr_aying
spreading1339653spreading
sprigging1435893sprigging
springing1338743springing
spritzing2135393spritzing
sprouting1236943sprouting
squinting1936223squinting
squirting1934793squirting
staging93818373st__aging
stagnating1254973stagnating
staining9413373stai_ning
staking123919803st__aking
staling83925423st__aling
staning83922243st__aning
stargazing2193323stargazing
staring84527053st__aring
starting93116173st_arting
statin63921473st__atin_
statins73719773st__atins
staving113915703st__aving
staying114017323st__aying
steading103613593st_eading
stealing93416603st_ealing
steaming114013213st_eaming
stetting93410713st_etting
sticking153513463st_icking
stiffing15248703st_iffing
stifling122110913st_ifling
stilling93415323st_illing
stimying1437503st_imying
stinging103213453st_inging
stinking133113543st_inking
stirring9299653st_irring
stotting92811163st_otting
straighting1644073straighting
strain64919573str_a_in_
strains74218153str_a_ins
straiten838613straiten_
straitening1243663straitening
straitens946243straitens
stranding1149653stranding
strang75718313str_a__ng
strapping1436993strapping
strati63518903str_ati__
stratify1445703str_atify
stravaging1543723stravaging
streakings15235303streakings
streamings13185163streamings
streeking14217453streeking
streeling10189483streeling
stressing1038333stressing
strewing12289853str_ewing
striata7379953striat__a
striate74218953striat__e
striated93414153striat_ed
striates83417093striat_es
striatum1044473striat_um
strickling1744953strickling
striction1148983striction
strictions1249143strictions
stridulating1453513stridulating
string75327563str___ing
stringings1245233stringings
stripings12215203stri_pings
striplings1344183striplings
stroking132610943str_oking
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563str_owing
stroying122410593str_oying
strumming1454413strumming
stunting92811503st_unting
sublating12310983sublating
suiting83419003s_ui_ting
sulfating1338063sulfating
summating1437943summating
supinating1357833supinating
surfacing1545643surfacing
surnaming1245143surnaming
surtaxing1784143surtaxing
sweating123213023s_weating
syringing1435883syringing
tainting93613583_tainting
threating131010053threating
throating1398403throating
tilting83417103_t_ilting
tinting84620603_t_inting
titrating10310113titr_ating
toiting83217093_toi_ting
tracing103720153_tr_acing
trading93517973_tr_ading
traiking132511973_traiking
trailing92916093_trailing
training93015863_training
treading103515333_treading
triazin1638203_triazin_
triazine1738503_triazine
triazins1738353_triazins
tricing103417353_tri_cing
tricking152714513_tricking
trifling122411503_trifling
trigging11299583_trigging
trilling92815963_trilling
trimming13318653_trimming
trining82919213_tri_ning
tripling112712553_tripling
tripping133210923_tripping
trithing122811773_trithing
troaking133310973_troaking
trotting92510913_trotting
truanting1035603_truanting
trusting93411653_trusting
trysting12267053_trysting
twisting12427813_twisting
twitting12307223_twitting
uprating11311113upr_ating
urinating10310653_urinating
urticating1347353urticating
vitiating1338413vitiating
writing113713893_wri_ting

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.436409841.7
2DLD Change Limit1486412697.81319024.8
3Display Results2692690.1262134.9
 (SQL Overall)1786912698.37521336.2
 
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.