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

135 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
anise5512970(None) 
anile54634461anile
anime75423201anime
anis45746461anis_
anises64826691anises
arise56436431arise
abase76023482abase
abide86223712abide
abuse77119562abuse
advise10139222advise
afire86215912afire
agile65122262agile
agism84614062agism
agist66325582agist
agnize16329562agnize
agonise83112692agonise
ahis76135382ahis_
aide56045002a_ide
ains46158882ains_
ais39083572a_is_
aisle55223192a_isle
alike95523962alike
aline57243152aline
alist56136782alist
alive85722512alive
amice96122872amice
amide86128482amide
amie66339852ami_e
amies76837692amies
amine75835382amine
amis66445322amis_
amiss75823072amiss
amuse75920832amuse
anas46649862anas_
ands57833612ands_
ane37866952an__e
anele55628832anele
anes45255932anes_
angle64528872angle
angst6415492angst
ani37751182ani__
anil46437432ani_l
anils56326722anils
anima74620072anima
animes84719592animes
animi74016662animi
anion55028812anion
aniseed839402aniseed
anisic8313792anisic
anisole71010832anisole
ankle95220252ankle
anode65021042anode
anole55330382anole
ansa45927772an_sa
ansae55720972ansae
antae56828292antae
ante46538902an_te
antes56334322antes
antis55033312antis_
antisex1439692antisex
antre55224522antre
ants47243472ants_
antsy85712792antsy
anus47131112anus_
anuses66218772anuses
anywise1345202anywise
apish105116632apish
apse67725382a_pse
ariose64818722ariose
arisen65316792arisen
arises65233802arises
arose55832082arose
arse46539272a_rse
aside65122082aside
aviso85713962aviso
axile126020512axile
axis116127912axis_
axised14438962axised
axises134413992axises
axite125218252axite
azide155617162azide
azine146721412azine
banish111416042banish
bise66437102_bise
camise103319632camise
canine83826702canine
danish101513792danish
enisle63412092enisle
fanwise1336632fanwise
frise85322452frise
guise64717712guise
hanse85722792han_se
hoise85224772hoise
incise83515332incise
ionise63516942ionise
knife1210010132knife
knish1238602knish
kyanise14236142kyanise
lanose6313592lanose
manse75528232man_se
manwise1239182manwise
mise66043582_mise
naive85116212naive
nanism8311202nanism
nice65534712_nice
nide55535792_nide
nine45842172_nine
nisei54214352_nisei
nisi45823242_nisi
nite45943582_nite
nixe115722022_nixe
noise55723732noise
nose46739362_nose
paise75028332paise
pavise114714802pavise
peise75825772peise
poise75127892poise
prise74632612prise
raise54828052raise
ranis55235832ranis_
rinse54820972rinse
rise45945232_rise
sanies63031952sanies
seise54727852seise
snide64318722snide
snipe75320572snipe
tanist6324592tanist
unisex1358352unisex
unite54828382unite
unwise9510802unwise
valise92917642valise
vanish121513212vanish
vise75632672_vise
wise75737342_wise
zanies153219672zanies

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 Filter178691538000.313570897.8
2DLD Change Limit538001351.47036598.6
3Display Results1351350.0462934.8
 (SQL Overall)1786911351.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.