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

142 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
gamin8442299(None) 
amin66042241_amin
gain56042161ga_in
gamic103916191gamic
gamine94620151gamine
gaming104622041gaming
gamins94420041gamins
again65218112again
agamic113110542agamic
agamid103710672agamid
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amain74922882_amain
amen66733152_amen
ami56646802_ami_
amia66836892_amia
amid77036332_amid
amie66339842_amie
amine75835372_amine
amino75425492_amino
amins75534312_amins
amir65129742_amir
amis66445312_amis
ayin76331742_ayin
basin75026922basin
cabin94820932cabin
cain65643912ca_in
camion103917192camion
cumin94616972cumin
daman84821162daman
damn75724322dam_n
diamin9312512diamin
etamin81311852etamin
fagin9216572fagin
fain75840562fa_in
famine114318192famine
faming124922972faming
gabion93211022gabion
gadi66329722gadi_
gadid85517372gadid
gadis74825292gadis
gaeing84617222gaeing
gaen57329602ga_en
gaging94718402gaging
gagman103811242gagman
gagmen103910412gagmen
gaijin1445972gaijin
gains65729512ga_ins
gait56150192ga_it
gam67060062gam__
gama77035512gam_a
gamas85431352gamas
gamay116419102gamay
gamb96331842gam_b
gamba106018512gamba
gambe106219212gambe
gambia115912232gambia
gambir11509752gambir
gambit114714192gambit
gambs105721122gambs
game76644322gam_e
gamed95126392gamed
gamer84928942gamer
games86238552games
gamey115320552gamey
gamier93617932gamier
gamily123712182gamily
gamines103618462gamines
gamings114610912gamings
gamma106116102gamma
gamming133112622gamming
gammon1138902gammon
gammy135514892gammy
gamp98833212gam_p
gamps105323712gamps
gams76648882gam_s
gamut8322982gamut
gamy105427532gam_y
gan48060122ga__n
gaping105618922gaping
garni6315702garni
gaskin113610582gaskin
gasman92911742gasman
gasmen93111562gasmen
gating84826952gating
gauming11319712gauming
gaun56427712ga_un
gazing174717172gazing
gin46055752g__in
gradin83517482gradin
grain65126252grain
gratin74520582gratin
grin55733722g_rin
groin65521082groin
guanin7610802guanin
haemin113412662haemin
harmin113117392harmin
hemin103620932hemin
jasmin1538072jasmin
kain85334292ka_in
kami105823642kami_
kamik105011552kamik
kamsin1238322kamsin
lain46146282la_in
lamia75324322lamia
lamina84920442lamina
laming94528362laming
lapin75222922lapin
layin84720332layin
main65345502ma_in
mamie95826002mamie
matin75132852matin
mavin105722952mavin
naming93917892naming
pain65647242pa_in
patin76832852patin
pavin105623202pavin
rain46251732ra_in
ramen75625192ramen
rami66034092rami_
ramie75027822ramie
ravin85624652ravin
rawin85521472rawin
sabin74924942sabin
saimin8313662saimin
sain45551292sa_in
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
tain45548072ta_in
takin94921302takin
tamein8313082tamein
taming94023432taming
tamis76728722tamis
vain75233002va_in
wain75840192wa_in
yamen104115182yamen
yamun10419272yamun
zamia165115212zamia
zayin174512042zayin

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.0802233637.5
2DLD Change Limit538001421.92028020.8
3Display Results1421420.0334303.0
 (SQL Overall)1786911422.03387895.2
 
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.