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

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

199 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
string7532756(None) 
sering74731811sering
siring75128311siring
soring74731881soring
spring94526011spring
staring84527051staring
sting65330241st_ing
storing83921121storing
strang75718311strang
strings84617131strings
stringy114111071stringy
strong74914881strong
strung75213021strung
stying105414571stying
airing74927502airing
astringe938222astringe
baring95135852baring
boring94724872boring
bring85528502_bring
caring95137992caring
cering94522532cering
coring94433962coring
curing94824782curing
daring84928682daring
during84419402during
earing75235482earing
erring73816482erring
estrin6315922estrin_
estrins7315852estrins
faring105231282faring
firing104021722firing
goring84119572goring
gyring113910362gyring
haring104233002haring
hiring104421602hiring
iring66025422_iring
luring73820752luring
lustring9269722lustring
metring103215292metring
miring93723802miring
mitring103514142mitring
muring95120372muring
oaring74225302oaring
outring84021022outring
paring94236492paring
poring94227272poring
raring74332872raring
restring91518782restring
ring56541152__ring
sabring102614842sabring
sacring103115982sacring
saning75127642saning
sarin55239252sarin_
sarins63932622sarins
sarong73914872sarong
sating74735452sating
saving104724512saving
sawing104323812sawing
saying104325542saying
scaring103421972scaring
scoring103117212scoring
scrying1338662scrying
searing83330922searing
seeing74222142seeing
serging93416672serging
serin55434442serin_
serine65432672serine
seringa83310742seringa
serins64029672serins
serving113014982serving
setting83621392setting
sewing103819622sewing
sexing144313892sexing
sharing113723242sharing
shoring112820072shoring
shrine94920052shrine
shrink134511732shrink
shying134211842shying
siding83822132siding
sing57544172s__ing
siping94220632siping
siting74126622siting
sitting83519632sitting
sizing163616442sizing
skiing113610192skiing
skying14399982skying
sling66028802s_ling
sluing74315882sluing
snaring83920952snaring
snoring83917202snoring
soaring83521892soaring
soling74226822soling
sorbing102815262sorbing
sorings83817252sorings
sorning83116812sorning
sorting83221812sorting
souring83219062souring
sowing104222912sowing
sparing104823872sparing
spiring103918182spiring
sporing104319412sporing
sprang95713522sprang
sprig85617742spri_g
springe103913982springe
springs104415922springs
springy13359662springy
sprint84526792sprint
sprung94610032sprung
spuing94313362spuing
spying123913252spying
staging93818372staging
staig65519642stai_g
stain55727942stain_
stains64923652stains
staking123919802staking
staling83925422staling
stang66424682st_ang
staning83922242staning
starling93017122starling
starring92312952starring
starting93116172starting
starving122510172starving
stating83725162stating
staving113915702staving
staying114017322staying
steering93916792steering
stein54620542stein_
steins64818342steins
sterling93615552sterling
stewing113412492stewing
stingo74212162st_ingo
stings76220182st_ings
stingy105213202st_ingy
stink95122502st_ink
stint57037662st_int
stirring9299652stirring
stoking123615592stoking
stoning83717442stoning
stoping103716622stoping
storming11209422storming
storying12249672storying
stowing113315132stowing
strafing122111192strafing
strain64919572strain_
strains74218152strains
strand74514822strand
strange85416342strange
strawing122411622strawing
straying122912692straying
strewing12289852strewing
stria55723212stri_a
striae65422272striae
strick124813202strick
strict84821042strict
stride75420962stride
striding102713602striding
strife95318362strife
strike105619732strike
striking133012232striking
stringed102911872stringed
stringer93812942stringer
strip77524342stri_p
stripe85822442stripe
striping112612522striping
strips85719652strips
stript85222192stript
stripy115812742stripy
strive95020962strive
striving122611392striving
stroking132610942stroking
strowing122310562strowing
stroying122410592stroying
strunt64918912strunt
stung65417152st_ung
styling112910652styling
subring104116262subring
suing65026362s_uing
surfing112914482surfing
surging93115432surging
suturing9310372suturing
swing96124842s_wing
syringa11366352syringa
syringe11349472syringe
syrinx1637142syrinx
taring73932282taring
thing96622982_thing
ting56139902_t_ing
tiring74023092tiring
trig55528162_tri_g
trine54734602_trine
truing73913932_truing
trying104214072_trying
tsking114210422tsking
tying96019842_tying
tyring104613022tyring
unstring9312092unstring
waring105029442waring
wiring104521022wiring
wring95920712_wring

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511992.53332590.2
3Display Results1991990.0603316.7
 (SQL Overall)1786911992.93660862.1
 
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.