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

197 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
saint5514707(None) 
faint85837061faint
haint85436321haint
paint75443691paint
sain45551291sain_
sains55639971sains
saints65122421saints
skint95629231skint
stint57037661stint
suint55638181suint
taint55542281taint
ain37579102_ain_
ains46158892_ains
airt45757792_airt
ait38093912_ai_t
ant37270792_a_nt
aunt46553652_aunt
bait66556002bai_t
bint67355052_bint
cain65643912cain_
cains75334302cains
cant66362032ca_nt
dainty105311472dainty
daunt65929082daunt
dint56759062_dint
elint55436472elint
fain75840562fain_
faints94818782faints
feint84732252feint
flint87333502flint
gain56042162gain_
gains65729512gains
gainst74914702gainst
gait56150192gai_t
gaunt65430402gaunt
giant65430592giant
glint66830182glint
haints94417582haints
hant75461592ha_nt
haunt85229132haunt
hint77455752_hint
jaunt125025272jaunt
joint125227722joint
kain85334302kain_
kainit10414482kainit
kains96125652kains
lain46146282lain_
lint416266242_lint
main65345522main_
mains75635112mains
maist75535682maist
mint66758072_mint
pain65647242pain_
pains75138282pains
paints85921832paints
painty114714752painty
pant66061262pa_nt
pint66963182_pint
plaint85323202plaint
point75338732point
print74837462print
quaint15415172quaint
quint144529902quint
rain46251732rain_
rains55140232rains
rainy85921082rainy
rant45864682ra_nt
riant55833152riant
sabin74924952sabin_
sabine84020392sabine
sabins85521982sabins
sabot7931782sabot
sadist74221352sadist
saice75424052saice
said55742122sai_d
saids65328862saids
saiga64717932saiga
sail45447162sai_l
sails55738102sails
sained75424242sained
sainted84114242sainted
saintly1039342saintly
saith85826552saith
salient7419762salient
salina64221122salina
saline65132702saline
salt45758522sa_lt
sand55338472sa_nd
sane45954342sa_ne
sang55441242sa_ng
saning75127642saning
sanity9316202sanity
sank85236832sa_nk
sans45153362sa_ns
santo56227282sa_nto
sapient9415342sapient
sarin55239252sarin_
sarins63932622sarins
sasin54626572sasin_
sasins64923102sasins
sat36288482sa__t
satin55935222satin_
satinet7325282satinet
sating74735452sating
satins64930482satins
satiny93817982satiny
sault55834962sault
sauna54117552sauna
savant9416042savant
savin84625082savin_
savine94220282savine
saving104724512saving
savins93923132savins
sawing104323812sawing
sawn75428162sawn_
saying104325542saying
sayst85322002sayst
scant79735072scant
scent75831622scent
seine55732872seine
sent46963012s_ent
shent85933502shent
shift114225142shift
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirt84533902shirt
shist84829612shist
shit76745942shi_t
shunt85226512shunt
sift710740672s_ift
silt46558202s_ilt
sin36265902s_in_
sine46560632s_ine
sing57544182s_ing
sinh76238052s_inh
sink86640152s_ink
sins46755282s_ins
sit35877762s_i_t
skin85927542skin_
skink85916862skink
skins94723472skins
skirt95624672skirt
skit85437542ski_t
slain54923572slain_
slainte738542slainte
slant55238702slant
sling66028802sling
slink95422912slink
slipt76627482slipt
slit46250102sli_t
smit65138412smi_t
snit46342472sni_t
spait75631602spai_t
spent75532832spent
spilt75532222spilt
spin66231302spin_
spine76534422spine
spinet85629752spinet
spins75327982spins
spinto8410662spinto
spiny104921302spiny
spirt75032952spirt
spit65545082spi_t
splint85223282splint
sprint84526792sprint
squint154214792squint
stain55727942stain_
stains64923652stains
stent55634512stent
stilt54831982stilt
sting65330242sting
stink95122502stink
stints65119762stints
stunt55328172stunt
suing65026362suing
suints64617782suints
suit45649872sui_t
swain84919052swain_
swains94513952swains
swift116818052swift
swine85625302swine
swing96124842swing
swink125116352swink
tain45548072tain_
tains54936322tains
taints64520532taints
taunt55532282taunt
tint46758872_tint
vain75233002vain_
vaunt85925312vaunt
wain75840202wain_
wains86930872wains
waist86132382waist
wait75553692wai_t
want76156172wa_nt

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 Filter178691538000.310576422.6
2DLD Change Limit538001971.84329191.5
3Display Results1971970.0503940.0
 (SQL Overall)1786911972.20381112.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.