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

192 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
passant981394(None) 
pissant91012501pissant
askant10412712_askant
aslant6317752_aslant
assent65119952_assent
jessant1438442jessant
paesan85114092paesan_
paesani9348682paesani
paesano9338792paesano
paesans93312692paesans
pageant10312782pageant
paisan84417072paisan_
paisana94010222paisana
paisano9429512paisano
paisans93614752paisans
passade1039232passade
passado1037052passado
passage1039802passage
passband1344772passband
passing104318422passing
peasant9314922peasant
pissants1097362pissants
puissant10105392puissant
pulsant9310562pulsant
absent84016993_absent
alant55742293_a_lant
arrant6623253_arrant
asana5315483_a_sana
ascent84519653_ascent
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assault747413_assault
assay8710283_assa_y
assays977903_assays
assents74512223_assents
assert64922583_assert
asset55932263_ass_et
assist6314603_assist
assonant846803_assonant
assort64916383_assort
avant86224663_a_vant
basalt83519583ba_salt
basset85225383bass_et
bassett94213863bassett
bassinet10312843bassinet
bassist9312743bassist
bawsunt1244723bawsunt
brassart1047503brassart
brisant9312683brisant
callant94121223callant
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassena9287843cassena
cassene93111543cassene
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
castanet10416193castanet
descant104315593descant
discant103017263discant
dissent84018683dissent
distant83519953distant
gallant83517113gallant
gardant9314463gardant
gasman92911743gasman_
gassing94216333gassing
gossan747233gossan_
gossans836783gossans
instant7815353instant
issuant748263issuant
massa75518923massa__
massage1039893massage
massas85116463massa_s
massing104318023massing
messan83912063messan_
messans92710463messans
missent94318713missent
nascent9610523nascent
natant6318733na_tant
nauseant845743nauseant
paean77222723pa_ean_
paeans85118263pa_eans
paesanos10296703paesanos
pagan86121163pa_gan_
pagans95717923pa_gans
pageants1136693pageants
paint75443693pa__int
paisa76021073paisa__
paisanas10288873paisanas
paisanos10337553paisanos
paisas84317493paisa_s
pandani1039903pandani
pant66061263p___ant
parang93715513pa_rang
parasang1147333parasang
parent83230423pa_rent
parfait12312053parfait
parian83223963parian_
parians93519733parians
parlante1039693parlante
parsing103819553parsing
parson83817903parson_
parsons93516873parsons
partan83820563partan_
partans94418283partans
pascal10812373pasca_l
pascals11610013pascals
pasha105417183pasha__
pashas115117063pasha_s
pashing135120513pashing
pass65239953pass___
passable12310633passable
passably1537253passably
passades1139203passades
passados1146303passados
passaged1236243passaged
passages1139513passages
passaging1345613passaging
passalong1242523passalong
passbands1453983passbands
passe75525693pass__e
passed94320943pass_ed
passee84522023pass_ee
passel85117003pass_el
passels93913023passels
passer84721033pass_er
passers94717753passers
passes86030473pass_es
passim10410283pass_im
passings11409873passings
passion9310883passion
passions10310583passions
passive12239593passive
passkey1633563passkey
passport1247593passport
passus83610293pass_us
past65959013pa_s__t
pasta76624533pasta__
pastas85422873pasta_s
pastina93914593pastina
pasting103826553pasting
patent84524923pa_tent
patient9617073patient
pausal81511963pausa_l
pausing103912813pausing
pavan106518473pa_van_
pavane114113443pa_vane
pavans115715593pa_vans
payment14310703payment
peasants1038263peasants
peccant13311733peccant
pedant9319493p_edant
pendant10314853pendant
pennant9312493pennant
persalt9315413persalt
pessary1246873pessary
pheasant1347083pheasant
piassaba1242433piassaba
piassava1342253piassava
piquant1848003piquant
pissing103914803pissing
plant75437113p__lant
pleasant1048323pleasant
pliant83918823p_liant
posset84923253poss_et
present94022733present
psst66118403p_ss__t
ptisan8417973ptisan_
ptisans9317363ptisans
pursuant1046563pursuant
radiant82817133radiant
rampant11312173rampant
saltant7316773saltant
sassaby1244003sassaby
sassing84615553sassing
savant9416043sa_vant
scant79735073__scant
slant55238703__slant
taggant9310223taggant
tasset65925313tass_et
vacant11415133va_cant
vagrant11410663vagrant
valiant10314623valiant
variant10316803variant
vassal979243vassa_l
vassals1057953vassals
versant10313833versant
warrant10614243warrant
wassail1056133wassail
wessand1144833wessand

Search took 7 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 Limit1340271926.34321129.9
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.81226231.8
 
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.