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

209 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
swine8562530(None) 
dwine95616141dwine
gwine95513661gwine
seine55732871seine
shine85533091shine
sine46560621s_ine
spine76534421spine
swing96124841swing
swinge105614381swinge
swink125116351swink
swipe105217081swipe
swive115316191swive
twine85822361twine
wine74953421_wine
aline57243152aline
amine75835382amine
awing96827322awing
azine146721412azine
bine66650862_bine
brine75132272brine
chine105231722chine
cine66242942_cine
cline76428532cline
dine55555332_dine
dwined114610212dwined
dwines105013102dwines
exine125518492exine
fine75147952_fine
imine75821062imine
kine85643432_kine
koine9516482koine
lawine93316462lawine
line46965572_line
mine67256172_mine
nine45842172_nine
opine77422462opine
oscine8311562oscine
ovine86316642ovine
owing96222722owing
pine67755712_pine
sabine84020392sabine
saice75424052saice
sain45551292sain_
sained75424242sained
sains55639972sains
saint55147072saint
saline65132702saline
sane45954342s_ane
savine94220282savine
sawing104323812sawing
scene77220572scene
scone74621832scone
seined74023062seined
seiner64622482seiner
seines65029902seines
seise54727852seise
seize143819502seize
sene46848052s_ene
serine65432672serine
sewing103819622sewing
shin75634312shin_
shined104620782shined
shiner93820872shiner
shines95028912shines
shins85131042shins
shiny115122142shiny
shire84727132shire
shive114423422shive
shone83725982shone
shrine94920052shrine
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
sin36265892s_in_
since75024172s_ince
sines55954822s_ines
sinew84718922s_inew
sing57544172s_ing
singe65731132s_inge
sinh76238042s_inh
sink86640142s_ink
sins46755272s_ins
sipe67341042s_ipe
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skene96118122skene
skin85927532skin_
skink85916852skink
skins94723462skins
skint95629222skint
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
sling66028802sling
slink95422912slink
slipe75626132slipe
smile74823922smile
smite75224872smite
snide64318722snide
snipe75320572snipe
soigne74310032soigne
sone46649982s_one
sowing104222912sowing
sozine15712352sozine
spice95528812spice
spike114922842spike
spile75230082spile
spin66231302spin_
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spins75327982spins
spiny104921302spiny
spire75828692spire
spite75430662spite
spline86020532spline
stane55933002stane
stile54931572stile
stime76521802stime
sting65330242sting
stink95122502stink
stint57037662stint
stipe76523372stipe
stone55431182stone
suing65026362suing
suint55638182suint
suite54829562suite
supine84216692supine
swage94919562swage
swain84919052swain_
swains94513952swains
swale85221592swale
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sware85828212sware
swede94413202swede
swift116818052swift
swig85818022swi_g
swigs96213662swigs
swill83417372swill
swim96221402swi_m
swims105514142swims
swindle11389182swindle
swinged123810792swinged
swinger113812562swinger
swinges113413422swinges
swingle113510562swingle
swings104714452swings
swingy13489872swingy
swinked15349032swinked
swinks134610652swinks
swinney13365972swinney
swiped123811092swiped
swipes114114332swipes
swiple11379232swiple
swirl84514142swirl
swish115114822swish
swiss86712902swiss
swith115917402swith
swithe124010682swithe
swived133610632swived
swivel12369322swivel
swives123915182swives
swivet123615472swivet
swore84920822swore
swung95610562swung
syne75725762s_yne
thine85026862thine
tine45855132_tine
trine54734602trine
twice104711122twice
twin76023082twin_
twined104413122twined
twiner94012592twiner
twines94717272twines
twinge104210402twinge
twins85118982twins
twiny116012812twiny
urine55026602urine
vine75643682_vine
wane76344722_wane
whine116022812whine
wide85235412_wide
wife105228022_wife
wile75944372_wile
win66456292_win_
wince105220882_wince
wind85533852_wind
wined94434182_wined
wines85546862_wines
winey115325432_winey
wing86339222_wing
wink116435022_wink
wino75933612_wino
wins75949172_wins
winy107034322_winy
winze175014852_winze
wipe94830282_wipe
wire75839812_wire
wise75737342_wise
wite75443272_wite
wive105931752_wive
zine137036152_zine

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002091.59633709.3
3Display Results2092090.0464543.5
 (SQL Overall)1786912091.95291542.5
 
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.