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

103 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
pseudo93471(None) 
pseud867041pseud_
pseudos1044831pseudos
pseuds944791pseuds
escudo943372escudo
scudo85412212_scudo
speedo94011992speedo
credo84815563cre_do
eddo63411803__eddo
escudos1043493escudos
euro45325273__euro
feud86523023_feud_
feuds95914883_feuds
judo125315303__judo
kendo105113223_kendo
kudo96115103__kudo
leud57223423_leud_
leuds66214813_leuds
menudo945793menudo
overdo10128363overdo
paseo77022513pase__o
passado1037053passado
ped66751523p_e_d_
pedro8313153p_edro
peds75835243p_e_ds
peed76239183p_eed_
pend75934533p_end_
pends85527193p_ends
pengo84317593p_engo
pepo87622153p_e_po
perdu84216273p_erdu
perdy115417323p_erdy
pesade9311103pesade
peso66925823p_e_so
pesto75723723p_esto
petto76021043p_etto
pied75035363pie_d_
plead85818463plead_
pleads94613953pleads
pled75231433ple_d_
pleura837533pleura
pleuron976343pleuron
pneuma1035263pneuma
posed85828413pose_d_
poseur8419403poseu_r
poseurs9378283poseurs
preed85128113preed_
prelude1038013prelude
presto84216203presto
proud84615483proud_
prude84615973p_rude
pseudonym1792383pseudonym
pseudopod1552933pseudopod
psycho1674533psycho
pud65836653p__ud_
puds75630513p__uds
pueblo1035553pueblo
redo56029363_re_do
scud76221283_scud_
scudi85112163_scudi
scuds85116243_scuds
seadog838743_seadog
secco9312423_secco
sedum84115573_sedum
seed55549483_seed_
seeds64330063_seeds
seedy94821533_seedy
segno64814743_segno
sego56525183_se_go
seldom939403_seldom
send55237293_send_
sends65528243_sends
servo84516683_servo
sexto124415453_sexto
soldo67116563_soldo
spado83713703_spado
sped76031493spe_d_
speed85526623speed_
speedos10298263speedos
speeds94316053speeds
speedy1218410783speedy
spend85619333spend_
spends94714473spends
spendy124911143spendy
spud75818493_spud_
spuds85113673_spuds
spued84918473spued_
stud56220093_stud_
studio7247133_studio
studs64415873_studs
study94411793_study
sudd64719773_s_udd
sudor6312623_s_udor
suds56135293_s_uds
sued56537933_sued_
suede64419753_suede
sumo67326313_s_umo
testudo843363testudo
udo49027303___udo
upsend9356883upsend_
upsends10265293upsends
uredo65112993ure_do
used55722823use_d_

Search took 9 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161038.31313559.0
3Display Results1031030.0333121.2
 (SQL Overall)1786911038.46921099.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.