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

136 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
trusteed934653(None) 
trusted83412781trust_ed
trustee73514441trustee_
trustees8339321trustees
crusted103712752crust_ed
rusted75020922_rust_ed
rustled83311322_rustled
thrusted1265222thrust_ed
trussed84010012trus_sed
truster73114312trust_er
trusters83112242trusters
trustier8268682trustier
trusties82712852trusties
trysted11428272tryst_ed
blustered12157263blustered
bristled11187343bristled
bruited104110353bruit_ed
brushed133811213brus_hed
bruted95113263bru_t_ed
burseed1049503burs_eed
bursted1039423burst_ed
busted95123153_bust_ed
bustled104011513_bustled
clustered12186603clustered
cotrustee1145583cotrustee_
cotrustees1243323cotrustees
crested103416533crest_ed
crusaded1244233crusaded
crushed134111963crus_hed
crustier10259533crustier
dusted83918373_dust_ed
entrusted1065943entrust_ed
eructed10228653eruct_ed
erupted10207163erupt_ed
flustered13185883flustered
frosted113211873frost_ed
fruited11389093fruit_ed
grunted9339283grunt_ed
gruntled10274943gruntled
gusted84316723_gust_ed
hustled113210133_hustled
intrusted1076903intrust_ed
jousted15339143joust_ed
justed144215773_just_ed
justled15338093_justled
lusted74319443_lust_ed
lustered92510603_lustered
lustred8359053_lustred
musted93321073_must_ed
mustee83922103_mustee_
mustees94614923_mustees
mustered112511503_mustered
ousted73720583_oust_ed
reseed74823293_res_eed
rested74430783_rest_ed
rousted84013323roust_ed
rushed104419863_rus_hed
rushee93818773_rushee_
rushees103311953_rushees
rustier74416363_rustier
rustle63615413_rustle_
rustler73512343_rustler
rustles73416413_rustles
rutted74518403_ru_tted
sauteed8349613sau_teed
steed66024943___steed
strunted957243strunt_ed
strutted946343stru_tted
tasted74123973t_ast_ed
taunted84310963taunt_ed
tauted75317113tau_t_ed
tautened935423tau_tened
tested74421523t_est_ed
testee64323303t_estee_
testees74215913t_estees
thruster1135793thrust_er
thrusters1245313thrusters
toasted84011923toast_ed
toused74122013tous__ed
tousled84710363tous_led
touted74419743tou_t_ed
trashed113514693tras_hed
treated83618703treat_ed
treed65626733tr___eed
tressed83714253tres_sed
trestle72611363trestle_
trestles83012553trestles
triste63818643trist_e_
tristeza1742933tristeza
trothed114010973tr_othed
trotted83711283tr_otted
truanted935373truanted
truced95312053tru__ced
trucked143910813tru_cked
truckled15327313truckled
trudged10298043tru_dged
truebred1142753truebred
trued65117693tru___ed
truffled1563993truffled
trumped12439713tru_mped
trumpeted1443053trumpeted
trundled10306393trundled
trunked12358413tru_nked
trusser74010253trus_ser
trussers8348263trussers
trusses73813633trus_ses
trust55426853trust___
trusteeing1142893trusteeing
trustful1144363trustful
trustiest9239083trustiest
trustily11257103trustily
trusting93411653trusting
trustless955933trustless
trustor7238403trust_or
trustors8268893trustors
trusts64714433trust__s
trusty94710113trust__y
tryste9399583tryst_e_
tryster10369513tryst_er
trysters11298363trysters
trystes10419993tryst_es
tufted10359283t_uft_ed
turreted935373turreted
turtled8309683t_urtled
tushed104615893t_us_hed
tusked114112153t_us_ked
tussled835413t_ussled
tutee5423523t_u_tee_
tutees6514553t_u_tees
tutted75117443t_u_tted
tutued7349413t_u_tued
twisted11277433twist_ed
unrusted92310353unrust_ed
wrastled12346433wrastled
wrested113410933wrest_ed
wrestled12296763wrestled

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621367.20320291.8
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.40524131.1
 
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.