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

158 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
amirs7592492(None) 
airs46447431a_irs
amias75831471amias
amids85627521amids
amies76837691amies
amins75534321amins
amir65129751amir_
amis66445321ami_s
amiss75823071amiss
emirs76116161emirs
mairs76228301mairs
mirs66940581_mirs
abris75722612abris
acids87121012acids
adios65822862adios
adits66523712adits
admire949932admire
admires1038662admires
admits9411412admits
afars85716512afars
afire86215912afire
agars66120642agars
agers65027852agers
agios65919862agios
ahis76135382ahi_s
aids57846372a_ids
ails45654722a_ils
aimers84621912aimers
aims67738192a_ims
ains46158892a_ins
air38058402a_ir_
airn46433842a_irn
airns55521032a_irns
airt45757792a_irt
airts55626342a_irts
airy75734162a_iry
ais39083582a_i_s
aits46355542a_its
alias55834602alias
alifs86121262alifs
amahs107819062amahs
amas67746302am_as
amass77119682amass
ambers104519582ambers
ambits103713422ambits
ambos95321252ambos
ambry123512102ambry
ameers84015572ameers
amens75624842amens
ami56646812ami__
amia66836902ami_a
amice96122872amice
amices105018012amices
amici94217392amici
amicus103810002amicus
amid77036362ami_d
amide86128492amide
amides95722662amides
amido85720992amido
amidst94913232amidst
amie66339852ami_e
amiga85514812amiga
amigas95912172amigas
amigo86515472amigo
amigos94511212amigos
amin66042252ami_n
amine75835382amine
amines84727982amines
amino75425502amino
amity10416092amity
ammos94815822ammos
amnios84912522amnios
amoks11413552amoks
amort75832202amort
amours83512662amours
amps86230342am_ps
amus65529612am_us
amyls104512692amyls
anils56326722anils
anis45746472ani_s
apers76629132apers
arias55438042arias
arils58732202arils
armers85520272armers
armies85123692armies
armors85017812armors
arris56824682arris
ars37670932a__rs
auris55331532auris
avers85127312avers
axils127217502axils
axis116127912axi_s
ayins85321612ayins
coirs75221052coirs
damars93815002damars
emir65918702emir_
emits75421472emits
fairs85825442fairs
fakirs13468082fakirs
faqirs18456032faqirs
firs76637722_firs
flirs85518932flirs
gambirs12359082gambirs
gamers94420832gamers
gamins94420052gamins
hairs86225172hairs
heirs85618562heirs
imids86015152imids
kafirs13306982kafirs
kamiks11387912kamiks
keirs95313682keirs
kirs85831752_kirs
lairs55425872lairs
lamias85020612lamias
maars74621632maars
maids86327152maids
mails76037782mails
maims96321792maims
mains75635112mains
mair66133782mair_
mamies104626242mamies
mars66261872_mars
mibs85330492_mibs
mics87435162_mics
mids76541802_mids
migs76935332_migs
mils66045342_mils
mips85534092_mips
mir57046782_mir_
mire66748242_mire
mires75640882_mires
miri66730382_miri
mirk106729512_mirk
mirks115122142_mirks
miry96326762_miry
mis58162632_mi_s
miss65339432_miss
mors65950062_mors
nadirs7109002nadirs
namers84517332namers
noirs55615462noirs
omers76923192omers
omits75018262omits
pairs75325832pairs
ramies84630462ramies
sabirs85414632sabirs
sirs44338342_sirs
smirk116612752smirk
smirks124910122smirks
stirs55921622stirs
tamers84224032tamers
tamis76728732tami_s
tapirs84113172tapirs
vairs85019132vairs
wairs86424062wairs
weirs84316492weirs
whirs115218092whirs
zamias174212922zamias

Search took 5 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.843211970.3
2DLD Change Limit538001583.09317394.1
3Display Results1581580.0463434.8
 (SQL Overall)1786911583.98244874.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.