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
skint95629221skint
stint57037661stint
suint55638181suint
taint55542281taint
ain37579092_ain_
ains46158882_ains
airt45757782_airt
ait38093902_ai_t
ant37270782_a_nt
aunt46553652_aunt
bait66556002bai_t
bint67355032_bint
cain65643912cain_
cains75334302cains
cant66362022ca_nt
dainty105311472dainty
daunt65929082daunt
dint56759052_dint
elint55436472elint
fain75840562fain_
faints94818782faints
feint84732252feint
flint87333502flint
gain56042162gain_
gains65729512gains
gainst74914692gainst
gait56150192gai_t
gaunt65430402gaunt
giant65430592giant
glint66830182glint
haints94417582haints
hant75461582ha_nt
haunt85229132haunt
hint77455742_hint
jaunt125025272jaunt
joint125227722joint
kain85334292kain_
kainit10414482kainit
kains96125642kains
lain46146282lain_
lint416266232_lint
main65345502main_
mains75635092mains
maist75535672maist
mint66758042_mint
pain65647242pain_
pains75138282pains
paints85921832paints
painty114714752painty
pant66061252pa_nt
pint66963172_pint
plaint85323202plaint
point75338732point
print74837462print
quaint15415172quaint
quint144529902quint
rain46251732rain_
rains55140232rains
rainy85921082rainy
rant45864672ra_nt
riant55833152riant
sabin74924942sabin_
sabine84020382sabine
sabins85521972sabins
sabot7931772sabot
sadist74221352sadist
saice75424052saice
said55742112sai_d
saids65328852saids
saiga64717932saiga
sail45447162sai_l
sails55738102sails
sained75424242sained
sainted84114242sainted
saintly1039342saintly
saith85826552saith
salient7419762salient
salina64221122salina
saline65132702saline
salt45758522sa_lt
sand55338462sa_nd
sane45954332sa_ne
sang55441222sa_ng
saning75127642saning
sanity9316202sanity
sank85236822sa_nk
sans45153352sa_ns
santo56227282sa_nto
sapient9415332sapient
sarin55239252sarin_
sarins63932622sarins
sasin54626572sasin_
sasins64923102sasins
sat36288482sa__t
satin55935212satin_
satinet7325282satinet
sating74735452sating
satins64930482satins
satiny93817982satiny
sault55834962sault
sauna54117552sauna
savant9416042savant
savin84625082savin_
savine94220282savine
saving104724512saving
savins93923132savins
sawing104323812sawing
sawn75428162sawn_
saying104325542saying
sayst85322002sayst
scant79735072scant
scent75831622scent
seine55732872seine
sent46963012s_ent
shent85933492shent
shift114225132shift
shin75634302shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirt84533892shirt
shist84829602shist
shit76745932shi_t
shunt85226502shunt
sift710740662s_ift
silt46558192s_ilt
sin36265892s_in_
sine46560622s_ine
sing57544172s_ing
sinh76238042s_inh
sink86640142s_ink
sins46755272s_ins
sit35877752s_i_t
skin85927522skin_
skink85916852skink
skins94723462skins
skirt95624662skirt
skit85437522ski_t
slain54923572slain_
slainte738542slainte
slant55238702slant
sling66028802sling
slink95422912slink
slipt76627482slipt
slit46250102sli_t
smit65138402smi_t
snit46342472sni_t
spait75631602spai_t
spent75532832spent
spilt75532222spilt
spin66231302spin_
spine76534422spine
spinet85629752spinet
spins75327982spins
spinto8410662spinto
spiny104921302spiny
spirt75032952spirt
spit65545082spi_t
splint85223282splint
sprint84526792sprint
squint154214792squint
stain55727932stain_
stains64923652stains
stent55634512stent
stilt54831982stilt
sting65330242sting
stink95122502stink
stints65119762stints
stunt55328172stunt
suing65026362suing
suints64617782suints
suit45649872sui_t
swain84919052swain_
swains94513952swains
swift116818052swift
swine85625302swine
swing96124842swing
swink125116352swink
tain45548072tain_
tains54936322tains
taints64520532taints
taunt55532282taunt
tint46758862_tint
vain75233002vain_
vaunt85925312vaunt
wain75840192wain_
wains86930862wains
waist86132382waist
wait75553692wai_t
want76156162wa_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.0931921408.6
2DLD Change Limit538001971.92327977.1
3Display Results1971970.0603283.3
 (SQL Overall)1786911972.07686074.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.