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

106 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
passado103705(None) 
passade1039231passade
passados1146301passados
paesano9338792paesano
paisano9429512paisano
pashadom1643842pashadom
passades1139202passades
passadoes1245092passadoes
passage1039802passage
passant9813942passant
passed94320942passed_
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assays977903_assays
basso76017283bass__o
camisado1372943camisado
cascade12118603cascade
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassino93512433cassino
crusado1043923crusado
gambado1344973gambado
gassed85217633gassed_
jassid1467223jassid_
jassids1586143jassids
lasso55015683lass__o
massa75518923massa__
massage1039893massage
massas85116463massa_s
massed94421323massed_
pachadom1844183pachadom
paesan85114093paesa_n
paesani9348683paesani
paesanos10296703paesanos
paesans93312693paesans
paisa76021073paisa__
paisan84417073paisa_n
paisana94010233paisana
paisanos10337553paisanos
paisans93614753paisans
paisas84317493paisa_s
palisade1145833palisade
panada94113053pa_nada
papadom1466763pa_padom
parade94720643pa_rade
parador103311413pa_rador
parados103816053pa_rados
paradox17358173pa_radox
paramo102614653pa_ramo
parkade1437583parkade
parlando1145413parlando
parsed96323893parsed_
pascal10812373pasca_l
pascals11610013pascals
paseo77022513pa_s_eo
pasha105417183pasha__
pashadoms1743453pashadoms
pashas115117063pasha_s
pashed125923143pashed_
pass65239953pass___
passable12310633passable
passably1537253passably
passaged1236243passaged
passages1139513passages
passalong1242523passalong
passband1344773passband
passbands1453983passbands
passbook1643283passbook
passe75525693pass__e
passee84522023pass_ee
passel85117003pass_el
passels93913023passels
passer84721033pass_er
passers94717753passers
passes86030473pass_es
passim10410283pass_im
passing104318423passing
passion9310883passion
passive12239593passive
passkey1633563passkey
passus83610293pass_us
pasta76624533pasta__
pastas85422873pasta_s
pasted94426903pasted_
pausal81511963pausa_l
paused95114963paused_
pesade9311103p_esade
pessary1246873pessary
piassaba1242433piassaba
piassava1342253piassava
pintado1096573pintado
pissant91012503pissant
pissed94816933pissed_
posada937163p_osada
pseudo934713p_seudo
sapsago1044303sapsago
sassaby1244003sassaby
sassed76116173sassed_
spado83713703__spado
tostado895953tostado
vassal979243vassa_l
vassals1057953vassals
wassail1056133wassail

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 Limit1340271066.32621186.7
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.77826363.4
 
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.