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

318 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
gain5604216(None) 
again65218111again
agin56132711agin
ain37579091_ain
cain65643911cain
fain75840561fain
gaen57329601gaen
gains65729511gains
gait56150191gait
gamin84422991gamin
gan48060121ga_n
gaun56427711gaun
gin46055751g_in
grain65126251grain
grin55733721grin
kain85334291kain
lain46146281lain
main65345511main
pain65647241pain
rain46251731rain
sain45551291sain
tain45548071tain
vain75233001vain
wain75840191wain
aging77026352aging
agio57828452agio
agon56531882agon
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ains46158882_ains
air38058392_air
airn46433832_airn
ais39083572_ais
ait38093902_ait
akin86328032akin
amain74922892amain
amin66042252amin
an211879072_a_n
ani37751172_ani
awn68035912_awn
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
ban58366832ba_n
bani65334952bani
barn66444642barn
basin75026922basin
bin56658642_bin
blain75421792blain
blin67228172blin
brain76229382brain
brin67038192brin
cabin94820942cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760132ca_n
carn66245432carn
chain105723672chain
chin96934742chin
coin66645352coin
dais57040702dais
damn75724322damn
dan46859662da_n
darn56434622darn
dawn85624202dawn
din46459462_din
djin12911632djin
drain65222892drain
earn46737552earn
elain55324702elain
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158852fa_n
faun76226622faun
fawn105321952fawn
fin66458032_fin
foin77231562foin
gab67155992ga_b
gabion93211032gabion
gabs76740422gabs
gaby107123192gaby
gad57556652ga_d
gadi66329722gadi
gadid85517372gadid
gadis74825292gadis
gads67843382gads
gae46457702ga_e
gaed66031512gaed
gaeing84617222gaeing
gaes56348032gaes
gaff114828152gaff
gag57753632ga_g
gaga66625552gaga
gage65936102gage
gaging94718402gaging
gags66441062gags
gaijin1445972gaijin
gaily95020972gaily
gained84617462gained
gainer74117492gainer
gainly1049322gainly
gainst74914692gainst
gaits65726012gaits
gal46055512ga_l
gala55635162gala
gale56347322gale
gall56335992gall
gals57946502gals
gam67060062ga_m
gama77035512gama
gamb96331842gamb
game76644322game
gamic103916192gamic
gamine94620152gamine
gaming104622042gaming
gamins94420042gamins
gamp98833212gamp
gams76648882gams
gamy105427532gamy
gane55145292gane
gang66031962gang
gaol56925412gaol
gap67055612ga_p
gape75134512gape
gaping105618922gaping
gaps76042972gaps
gapy106320912gapy
gar47259902ga_r
garb75332672garb
garni6315702garni
gars55750742gars
gas48870252ga_s
gash86833022gash
gaskin113610582gaskin
gasp76227332gasp
gast56052562gast
gat46880512ga_t
gate55746572gate
gating84826952gating
gats56753442gats
gaud67025432gaud
gaum75726422gaum
gaunt65430402gaunt
gaur56723352gaur
gave84634052gave
gawk126716692gawk
gawp107618632gawp
gay76856492ga_y
gays87338022gays
gaze145032412gaze
gazing174717172gazing
gen45950512g_en
ghi77019882ghi_
ghis85020162ghis
giant65430592giant
gib66443532g_ib
gid57047262g_id
gie47149542g_ie
gien56330022gien
gig56040752g_ig
gink97129522g_ink
gins55543952g_ins
gip67645362g_ip
girn56026862girn
git46266052g_it
glair65313552glair
glen56027202glen
glia56423152glia
glib79421442glib
glim76026352glim
glint66830182glint
gnawn9517782gnawn
going75218492going
goon57236172goon
gown85724072gown
gradin83517482gradin
grail64622872grail
grains74223092grains
grainy103914212grainy
gran56335012gran
gratin74520582gratin
grid65829612grid
grig65424772grig
grim76929422grim
grind75917562grind
grins65427222grins
grip76127022grip
grit55247242grit
groin65521082groin
guan55325582guan
guanin7610802guanin
guid66022822guid
gun47240802g_un
gwine95513662gwine
haen76229452haen
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
hin67559562_hin
in28150862__in
jail115529092jail
jin106443932_jin
join116724832join
kaif116933932kaif
kail85131492kail
kains96125642kains
kaon87521022kaon
karn86129412karn
kin76353962_kin
laic65931562laic
laid56439142laid
lair45934152lair
lapin75222922lapin
lawn75925632lawn
layin84720332layin
lin37967372_lin
loin46838722loin
maid75537642maid
mail65543442mail
maim85831482maim
mains75635102mains
mair66133772mair
man57465852ma_n
matin75132852matin
maun65727202maun
mavin105722952mavin
mawn94424132mawn
naan47621932naan
naif76839022naif
nail45838652nail
nan37854872na_n
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466442pa_n
patin76832852patin
pavin105623202pavin
pawn94625302pawn
pein65834942pein
pian66136092pian
pin57066722_pin
plain74823302plain
pyin96823232pyin
qaid146023842qaid
quin135823922quin
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
ran38266612ra_n
rani46640102rani
ravin85624652ravin
rawin85521472rawin
regain74517762regain
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924952sabin
said55742112said
sail45447162sail
sains55639972sains
saint55147072saint
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
sawn75428162sawn
shin75634302shin
sin36265892_sin
skin85927522skin
slain54923572slain
spin66231302spin
stain55727932stain
swain84919052swain
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167562ta_n
tarn46842722tarn
thin76732382thin
tin36362172_tin
train56529112train
twain86313622twain
twin76023082twin
tyin76424002tyin
vail75432552vail
vair75624142vair
van66246322va_n
vein75625752vein
waif105836752waif
wail75238822wail
wains86930862wains
wair75830052wair
wait75553692wait
wan66761932wa_n
warn75239322warn
whin105225692whin
win66456292_win
yarn75230042yarn
yawn106219092yawn
yin67648732_yin
zayin174512042zayin
zein135620602zein
zin125643772_zin

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 Filter178691298720.0802233637.5
2DLD Change Limit298723181.04628558.3
3Display Results3183180.0764184.2
 (SQL Overall)1786913181.202148661.4
 
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.