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

144 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
maist7553568(None) 
maists85817571maists
mast65959961ma_st
mayst106622671mayst
mist66154531m_ist
moist76033581moist
waist86132381waist
agist66325582agist
airt45757782_airt
ais39083572_ais_
ait38093902_ai_t
aits46355532_aits
alist56136782alist
amidst94913232amidst
amis66445322amis_
amiss75823072amiss
bait66556002bai_t
baits76630582baits
bast66362412ba_st
canst74932212canst
cast67159902ca_st
cist67244962_cist
dais57040702dais_
daisy95915312daisy
deist64633592deist
east46659102ea_st
exist124618942exist
faint85837062faint
fast77052312fa_st
feist86230072feist
fist76248422_fist
foist85730972foist
gainst74914702gainst
gait56150192gai_t
gaits65726012gaits
gast56052562ga_st
gist56046762_gist
grist65529872grist
hadst93220222hadst
haint85436322haint
hast76259482ha_st
heist87030912heist
hist76551542_hist
hoist86433212hoist
imagist1077332imagist
joist125125652joist
karst97228992karst
kist86540802_kist
last46260322la_st
list47055342_list
macs86742512macs_
mads76845372mads_
maes66948402maes_
magot8326392magot
mags75444532mags_
maid75537662mai_d
maids86327142maids
mail65543452mai_l
maile75232222maile
maill74420792maill
mails76037782mails
maim85831492mai_m
maims96321792maims
main65345522mai_n
mains75635112mains
mair66133782mai_r
mairs76228302mairs
maize164618562maize
malt66254812ma_lt
malts76331752malts
manat76039992manat
mans66354552mans_
manse75528232manse
maps86141052maps_
marish114319052marish
mars66261872mars_
marse76231152marse
marsh105320852marsh
mart66865982ma_rt
marts77442232marts
mas58175822ma_s_
masa65034722ma_sa
mash96039402ma_sh
mask105227362ma_sk
mass66044942ma_ss
massa75518922massa
masse75125292masse
massy104518962massy
masts77035762ma_sts
mat58083942ma__t
matiest92522452matiest
mats65460292mats_
matt65752662ma_tt
matts76829182matts
maut65448452ma_ut
mauts75927192mauts
mavis105622722mavis_
maws96437142maws_
maxis145721562maxis_
mayest114614792mayest
mays96940032mays_
maziest183613872maziest
miasm91211092miasm
midst85922552midst
milt65455812m_ilt
mint66758062m_int
mis58162622m_is_
mise66043582m_ise
miso67229902m_iso
miss65339422m_iss
mists76633902m_ists
misty106120452m_isty
mitt66145492m_itt
mixt136831922m_ixt
monist84324982monist
most66554202m_ost
must65145442m_ust
neist54628442neist
oast47156322oa_st
odist6421912odist
paint75443692paint
paisa76021072paisa
paise75028332paise
papist102618752papist
past65959012pa_st
racist82822792racist
rais45252622rais_
raise54828052raise
rapist82520672rapist
sadist74221352sadist
saint55147072saint
sayst85322002sayst
shist84829612shist
taint55542282taint
tanist6324592tanist
twist86820982twist
vast75045122va_st
waists97415452waists
wait75553692wai_t
waits88333522waits
wast75655852wa_st
whist115322952whist
wist78049292_wist
wrist84827562wrist

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.343520965.0
2DLD Change Limit538001441.79629955.5
3Display Results1441440.0334363.6
 (SQL Overall)1786911442.17282270.3
 
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.