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

173 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
saining8362139(None) 
gaining94015661gaining
paining103920241paining
raining83922691raining
sailing83927371sailing
sainting93215731sainting
saning75127641sa_ning
seining84020771seining
shining113816521shining
staining9413371staining
aiding84423612_aiding
ailing74331012_ailing
aiming94320842_aiming
airing74927502_airing
alining81917042alining
asinine7310722asinine
awning105013392_awning
bailing103723522bailing
baiting103918882baiting
baning95127832ba_ning
banning103818232banning
barning104320352barning
braining113414682braining
brining103216472brining
cabining1338642cabining
caning94128622ca_ning
canning103620132canning
chaining142810782chaining
chining133316842chining
coining103920552coining
damning114211632damning
darning93817332darning
dawning124111012dawning
dining84525132_dining
draining103312672draining
dwining12269292dwining
earning83418212earning
failing113521332failing
fainting123312162fainting
fairing113614012fairing
fanning113615072fanning
fawning14409132fawning
fining104223212_fining
foining113013452foining
gaiting93716582gaiting
graining102813182graining
hailing113820692hailing
jailing153415842jailing
joining153011482joining
lairing83715342lairing
lining74526802_lining
mailing102923342mailing
maiming122912722maiming
manning103616382manning
mining94225452_mining
nailing83419962nailing
opining10311742opining
paiking143814812paiking
painting113614422painting
pairing103716732pairing
panning104019392panning
patining11312302patining
pawning134711412pawning
peining104619152peining
pining93726532_pining
plaining113911552plaining
raiding93617592raiding
railing83325642railing
raising83220532raising
ravining12269692ravining
reining84425322reining
ruining83514882ruining
sabbing123314742sabbing
sabeing102611862sabeing
sabring102614842sabring
sacking144122702sacking
sacring103115982sacring
sagging103116102sagging
sailings93513252sailings
saimin8313662saimin_
saimins9312112saimins
salting84120792salting
salving113913152salving
sanding93520602sanding
sapling103217862sapling
sapping123519312sapping
sardining1137572sardining
sashing114621472sashing
sassing84615552sassing
sating74735452sa_ting
saucing10311002saucing
saunaing937012saunaing
saving104724512sa_ving
sawing104323812sa_wing
saying104325542sa_ying
scanning113310772scanning
seising84018862seising
seizing174114832seizing
shinning123211022shinning
shrining122610852shrining
siding83822132s_iding
signing92713962signing
singing93221422s_inging
sinking123320542s_inking
sinning83918442sinning
siping94220632s_iping
siring75128312s_iring
siting74126622s_iting
sizing163616442s_izing
skeining1347072skeining
skiing113610192ski_ing
skinking12299772skinking
skinning13327892skinning
skiting123812502skiting
skiving15298372skiving
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
slinging103312862slinging
slinking133412982slinking
sliping103314412sliping
smiling103915442smiling
smiting103014442smiting
snailing92912972snailing
sniping103712052sniping
soiling83422322soiling
sorning83116812sorning
spanning113311082spanning
spawning14296912spawning
spicing123914532spicing
spiking144312882spiking
spiling102919702spiling
spinning113310812spinning
spiring103918182spiring
spiting103917622spiting
splining11310772splining
spraining1248152spraining
staning83922242staning
stinging103213452stinging
stinking133113542stinking
stinting93415742stinting
stoning83717442stoning
straining10410562straining
suiting83419002suiting
sunning83715672sunning
swanning12338812swanning
swinging133411112swinging
swinking163410322swinking
swiping13319822swiping
swiving14358952swiving
tailing82923102tailing
tainting93613582tainting
tanning83618252tanning
tining74927542_tining
training93015862training
trining82919212trining
twining113211442twining
vailing113817952vailing
vanning113912462vanning
veining114713892veining
vining104619462_vining
waifing142910892waifing
wailing113620902wailing
wairing113414312wairing
waiting113618952waiting
waiving14329632waiving
waning103623802wa_ning
wanning113816212wanning
warning113717092warning
whining143311672whining
wining103625052_wining
yarning113512952yarning
yawning14378342yawning

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711733.53030501.7
3Display Results1731730.0632746.0
 (SQL Overall)1786911733.96945021.7
 
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.