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 “sansars” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

465 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
sansars7331391(None) 
sangars83116251sangars
sansar63613391sansar_
sarsars73512141sarsars
anears63717182_anears
caesars9410732caesars
hangars114313492hangars
hansas94616042hansa_s
kantars11310032kantars
mansard1049312mansard
mansards1148012mansards
saggars93610682saggars
salsas65316132salsa_s
sambars115113842sambars
samsara936912samsara
samsaras1045872samsaras
sandals82715202sandals
sandbars11108782sandbars
sanders84025942sanders
sangar73617692sangar_
sangas75222662sanga_s
sangers84421942sangers
sanjaks1834962sanjaks
sanseis73011602sanseis
santirs7312962santirs
santurs7310762santurs
sardars83112902sardars
sarsar63011842sarsar_
sensors73514642sensors
sonars64818972son_ars
afars85716513_a_fars
agars66120643_a_gars
altars64518153_altars
anas46649863_an_a_s
anear55420323_anear_
angary10311323_angary
angas65827993_anga_s
angers75222543_angers
anlas55626933_anla_s
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
ansa45927773_ansa__
ansae55720973_ansa_e
ansate64517863_ansate
answers1037043_answers
antas55432033_anta_s
antiars7314623_antiars
asanas6514113asan_a_s
ashlars10297063ashlars
assais6711963_assais
assays977903_assays
attars64515313_attars
balsams11579013balsams
balsas86417523balsa_s
bandas95120543banda_s
banders104324563banders
bandsaws1444623bandsaws
bangers104020353bangers
banians9312033banians
bankers133919093bankers
banners94018713banners
bantams1149063bantams
banters94623113banters
banyans1237913banyans
banzais1837163banzais
bazaars18275883bazaars
bazars174613113ba_zars
bursars94510893bursars
caesar8410933caesar_
calcars11312653calcars
canals84421673can_als
canard9314763can_ard
canards10311203can_ards
canary11314693can_ary
cancans11311873cancans
cancers114018583cancers
candors104216763candors
caners84629203can_ers
cankers134418753cankers
cannas84518403canna_s
canners93822663canners
canoers94318373canoers
cansos84915383cans_os
cantals93919573cantals
canters94827733canters
cantors94620753cantors
canvas113813333canva_s
canvass12376873canvass
casas75327843ca_sa_s
causals91411183causals
causers94014793causers
caviars1238623caviars
censers94313903censers
censors93611843censors
damars93815003da_mars
dammars12308193dammars
dancers103413093dancers
danders93921183danders
dangers94818213dangers
danseurs933433danseurs
darbars10510093darbars
daystars1243903daystars
denars74621433den_ars
dinars75417563din_ars
fanfare1336673fanfare
fanfares1436773fanfares
fangas105017203fanga_s
fanners103914653fanners
gainsays1243513gainsays
ganders93521703ganders
gangers94418603gangers
ganjahs18104003ganjahs
ganjas14149113ganja_s
gassers84714633gassers
gaydars1235803gaydars
gazars164811553ga_zars
gnars66718853_gn_ars
haars85620473ha__ars
handcars1437623handcars
handers114224333handers
handsaws1545873handsaws
hangar104114523hangar_
hangers113120813hangers
hankers144218133hankers
hansa85416783hansa__
hansels104011663hansels
hanses95022633hans_es
hansoms12238523hansoms
hawsers13409483hawsers
hussars10326983hussars
instars7411133_instars
invars9310003_invars
jaguars1535233jaguars
janisary1843623janisary
kabars124513953ka_bars
kaisers11369273kaisers
kanas95326913kan_a_s
kanbans1337723kanbans
kantar10311153kantar_
knars94416113_kn_ars
lahars94013163la_hars
lanais6316793lan_ais
lancers93616643lancers
landaus8310343landaus
landers84026213landers
langurs889103langurs
laniard868523laniard
laniards967313laniards
laniary1068013laniary
lanners73618333lanners
lanyard1167293lanyard
lanyards1266393lanyards
lapsers93911053lapsers
lascars979013lascars
lasers64925703la_sers
lazars153812393la_zars
lunars65012813lun_ars
maars74621633ma__ars
makars124612633ma_kars
malars85020683ma_lars
manas76240433man_a_s
manats84623463man_ats
mangas94122933manga_s
mangers103521263mangers
maniacs114313063maniacs
manias84029033mania_s
mannans93611523mannans
mannas85019803manna_s
manners93417833manners
manors84420883man_ors
manses84225513mans_es
mantas85725363manta_s
mantras93815863mantras
manuals9311223manuals
manuary1237773manuary
manward1349093manward
manwards1447613manwards
masas75630413ma_sa_s
masers84623453ma_sers
massas85116463massa_s
matsahs1236563matsahs
mensas85115863mensa_s
nanas55928633nan_a_s
nasals63312463na_sals
navars92810573na_vars
naysays1344123naysays
nears55529423__nears
nonwars10109003nonwars
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
pandas95521963panda_s
panders103423733panders
pangas99921113panga_s
paniers94717333paniers
panners93621273panners
pansies94521983pansies
panzers184012013panzers
parsers94118153parsers
passers94717753passers
pausers94113223pausers
pulsars9358913pulsars
qanats154112813qan_ats
qindars17267423qindars
qintars16268573qintars
quasars1646903quasars
radars71314673ra_dars
raisers73617393raisers
rancors9811373rancors
randans8313213randans
rangers83621043rangers
rankers113217463rankers
ransack1346463ransack
ransacks1445773ransacks
ransoms92410163ransoms
ranters73323643ranters
rasers64526783ra_sers
rinsers73815743rinsers
sabals84618863sa_bals
sabbats1138633sabbats
sabers85224733sa_bers
sabirs85414633sa_birs
sabras85116363sabra_s
sackers133820223sackers
sacrals93311793sacrals
safari91110223sa_fari
safaris101110663sa_faris
sagas66025883sa_ga_s
saggar84010853saggar_
saggard10358953saggard
saggards11397493saggards
saggers94017083saggers
saguaro845513saguaro
saguaros944973saguaros
sahuaro1044233sahuaro
sahuaros1154283sahuaros
saigas74114293saiga_s
sailers73822323sailers
sailors73213723sailors
sakers104125433sa_kers
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
salary9515213sa_lary
salpas85116923salpa_s
salsa56718923salsa__
salters73622253salters
salvers103916003salvers
salvors103910913salvors
samara8313853sa_mara
samaras9312913sa_maras
sambals115213483sambals
sambar103914163sambar_
sambas104219263samba_s
sambhars1544833sambhars
samburs11369343samburs
samosas939303samosa_s
samovars1343703samovars
sampans112411003sampans
samshus12125353samshus
sandal73317283sanda_l
sandarac1145833sandarac
sandaracs1244703sandaracs
sandbags1296373sandbags
sandbar10108193sandbar_
sandburs11105623sandburs
sanddabs1243903sanddabs
sander74828533sander_
sandhis1139993sandhis
sands65228583san__ds
sandsoaps1243683sandsoaps
sandspurs1242583sandspurs
saner54334323san_er_
sanes55649073san__es
sanga66023803sanga__
sangaree949333sangaree
sangarees1046543sangarees
sanger74524573sanger_
sanghs105312073san_ghs
sanies63031953san_ies
sanious7514103sanious
sanitary1146753sanitary
sanjak1735693sanja_k
sannops936693sannops
sannups934463sannups
sans45153363san___s
sansei63411903sans_ei
sanserif1146133sanserif
sanserifs1244663sanserifs
santera7311303santera
santeras8311063santeras
santero7311133santero
santeros8311193santeros
santims9312603santims
santir6315253santir_
santols73513323santols
santoors837633santoors
santos64421833san_tos
santours837183santours
santur6311273santur_
sapors84118813sa_pors
sapours93610623sapours
sappers113518903sappers
sapsago1044303sapsago
sapsagos1143773sapsagos
sarans64224433sa_rans
sardar73013173sardar_
sarsens7311393sarsens
sartors7314973sartors
sashays1336333sashays
sashes94728483sa_shes
sasins64923103sa_sins
sass45035623sa_s__s
sassaby1244003sassaby
sassafras1251803sassafras
sasses64124393sa_sses
sassies74719263sassies
satara6315533sa_tara
sataras7315063sa_taras
satays94411683sa_tays
satraps95011643satraps
satyrs937963sa_tyrs
saucers93712133saucers
saugers83914053saugers
saunas63915433sauna_s
saunters82911753saunters
sausage847193sausage
sausages937003sausages
savers93825923sa_vers
saviors1058993saviors
savors95616103sa_vors
savours10389343savours
sawers94620163sa_wers
sawyers13317533sawyers
sayers94221593sa_yers
scalars93711903scalars
scandals1136993scandals
scanners10379703scanners
scars75433533s__cars
sears54744913s__ears
secpars1138413secpars
seesaws1034703seesaws
seggars9377783seggars
seisers73816393seisers
seisors73212843seisors
senary93716073sen_ary
sendals81912273sendals
senders83022353senders
senhors103512133senhors
seniors73413623seniors
sennas64214233senna_s
senoras72714953senoras
senors63620793sen_ors
sensa54117473sensa__
sensate7311893sensate
sensates8511143sensates
senseis73310643senseis
senses63923943sens_es
sensor63813843sensor_
sensory10329093sensory
sewars94018633s_ewars
shears93820903s_hears
shikars1436183shikars
shmears1277073shmears
shnaps1148083shn_aps
shofars1335833shofars
simars84916933s_imars
singers83824703singers
sinkers113618543sinkers
sinners74019023sinners
sinters74024083sinters
sirdars8228213sirdars
sisals63013573s_isals
sitars65417593s_itars
sizars154812623s_izars
skankers11316483skankers
slanders94014013slanders
smears84714433s_mears
snags64421313s_n_ags
snaps74719563s_n_aps
snare54429983s_n_are
snarers74216663snarers
snares65329033s_n_ares
snarf86525423s_n_arf
snarfs95113423s_n_arfs
snark95419943s_n_ark
snarks104815733s_n_arks
snarl54921083s_n_arl
snarls64016873s_n_arls
snashes105214753snashes
snaws86116363s_n_aws
sneaks104312493s_neaks
sneaps84510863s_neaps
sneers64016173s_neers
soars54732513s__oars
sofars94712783s_ofars
sonar56523423son_ar_
sonders83820713sonders
soucars938423soucars
sowars94318013s_owars
sowcars1236013sowcars
spankers14369863spankers
spanners103710773spanners
spars75431543s__pars
spears84019473s_pears
sponsors1045753sponsors
standard1046253standard
standards1145203standards
standers93514303standers
stannary1144613stannary
stanzas1636363stanza_s
stars55836573s__tars
sudsers83310423sudsers
sugars7312423s_ugars
sundaes8313093sundaes
sunders84120053sunders
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunrays1037083sunrays
sunsets72911573sunsets
suntans72111733suntans
sunward1137653sunward
sunwards1236443sunwards
swanpans1343423swanpans
swears94114073s_wears
syncarp1444533syncarp
syncarps1543903syncarps
syngas10368913synga_s
talars66021683ta_lars
tanbark1337373tanbark
tanbarks1445563tanbarks
tankard1267263tankard
tankards1366253tankards
tankas104613773tanka_s
tankers113416913tankers
tanners74018393tanners
tansies74521243tansies
tantara72410823tantara
tantaras8269543tantaras
tantras73112093tantras
tanyard1167183tanyard
tanyards1276183tanyards
tarsals72512603tarsals
tartars73313403tartars
tatars64619793ta_tars
tensors72712373tensors
tsars56717113__tsars
tussars7359253tussars
unbars82113033_unbars
unsays9399543_unsays
vandals113211663vandals
vandas103915993vanda_s
vanners103612843vanners
vanward1456943vanward
vassals1057953vassals
wanders114221333wanders
wangans1149503wangans
wankers144514713wankers
wanters104420093wanters
warsaws1335763warsaws
yantras10259003yantras
zaffars22325233zaffars
zanders173015793zanders
zanzas1487053zanza_s

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274657.34318252.3
3Display Results4654650.1732687.9
 (SQL Overall)1786914657.92222556.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.