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

186 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
ayin7633174(None) 
agin56132711agin
ain37579091a_in
akin86328031akin
amin66042241amin
ayins85321611ayins
layin84720331layin
pyin96823231pyin
tyin76424001tyin
yin67648731_yin
zayin174512041zayin
abying124410412abying
acid77533392acid
acing87429152acing
acini75718982acini
actin74922552actin
adit56443652adit
aeon45634612aeon
again65218112again
aging77026352aging
agio57828452agio
agon56531882agon
ahi68040232ahi_
ahing98928342ahing
ahis76135382ahis
ai211288392a_i_
aid49269072a_id
ail37171042a_il
aim57858212a_im
ains46158882a_ins
air38058392a_ir
airn46433832airn
ais39083572a_is
ait38093902a_it
alan46844082alan
algin65718762algin
alien56425582alien
alif76242132alif
align65016502align
aline57243152aline
alit46155692alit
aloin55227412aloin
amain74922882amain
amen66733152amen
ami56646802ami_
amia66836892amia
amid77036332amid
amie66339842amie
amine75835372amine
amino75425492amino
amins75534312amins
amir65129742amir
amis66445312amis
an211879072a__n
ani37751172ani_
anil46437432anil
anion55028812anion
anis45746462anis
anon46134852anon
anyon85615222anyon
apian75018332apian
aping87327232aping
aria46245422aria
arid57642712arid
aril45843022aril
auxin121411912auxin
avian84616052avian
avid88325962avid
avion84218342avion
awing96827322awing
awn68035912a_wn
axil116424452axil
axing138521372axing
axion1211316912axion
axis116127912axis
axon115524302axon
ay511773892ay__
ayah108022992ayah
aye67151762ay_e
ayes76543512ayes
ays67050292ay_s
azan136521782azan
azine146721412azine
azon135725052azon
basin75026922basin
baying125222582baying
bin56658632_bin
blin67228172blin
brin67038192brin
cabin94820932cabin
cain65643912cain
chin96934742chin
coin66645352coin
cyan96419622cyan
din46459462_din
djin12911632djin
dying105316032dying
eyen76223662eyen
eying96117922eying
fagin9216572fagin
fain75840562fain
faying134521072faying
fin66458032_fin
foin77231562foin
gain56042162gain
gamin84422992gamin
gin46055752_gin
grin55733722grin
haying134420612haying
hin67559562_hin
hying126514742hying
hymn12311312hymn
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
kin76353962_kin
lain46146282lain
lapin75222922lapin
laying104525702laying
layins93817652layins
lin37967372_lin
loin46838722loin
lying95717452lying
lysin84512782lysin
main65345502main
matin75132852matin
mavin105722952mavin
mayan105616902mayan
maying124421152maying
mayvin1436522mayvin
pain65647242pain
patin76832852patin
pavin105623202pavin
paying123722162paying
pein65834942pein
pin57066722_pin
pyic116915822pyic
pyins105815862pyins
quin135823922quin
rain46251732rain
ravin85624652ravin
rawin85521472rawin
raying105027192raying
rayon83815702rayon
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924942sabin
sain45551292sain
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
sayid95516722sayid
saying104325542saying
shin75634302shin
sin36265892_sin
skin85927522skin
spin66231302spin
syn67024122sy_n
tain45548072tain
takin94921302takin
thin76732382thin
tin36362172_tin
twin76023082twin
tying96019832tying
tyiyn11635332tyiyn
vain75233002vain
vein75625752vein
vying125111812vying
wain75840192wain
whin105225692whin
win66456292_win
wyn95921442wy_n
wynn105811292wynn
yarn75230042yarn
yawn106219092yawn
yen66847382_yen
yid76640822_yid
yins75335122_yins
yip87241172_yip
yon67348952_yon
zayins18409712zayins
zein135620602zein
zin125643772_zin

Search took 1 second 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.0762351197.4
2DLD Change Limit298721860.84635309.7
3Display Results1861860.0464043.5
 (SQL Overall)1786911860.968184598.1
 
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.