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

193 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
trustees833932(None) 
trustee73514441trustee_
trusteed9346531trusteed
trusters83112241trusters
trusties82712851trusties
cotrustees1243322cotrustees
mustees94614922_mustees
rushees103311952_rushees
rustles73416412_rustles
testees74215912t_estees
thrusters1245312thrusters
trestles83012552trestles
trussers8348262trussers
trusses73813632trus_ses
trusted83412782trust_ed
truster73114312trust_er
trustier8268682trustier
trustiest9239082trustiest
trustless955932trustless
trustors8268892trustors
trusts64714432trust__s
trysters11298362trysters
trystes10419992tryst_es
tutees6514552t_u_tees
arrestees946233arrestees
blusters104413883blusters
bristles101510433bristles
bruiters10329133bruiters
brushers134210573brushers
brushes124014663brus_hes
brutes86118683bru_t_es
bursters1038983bursters
busters94724123_busters
bustles93816323_bustles
clusters102912393clusters
cotrustee1145583cotrustee_
crusades1146323crusades
cruses88127713crus__es
crusets93811043crus_ets
crushers134010083crushers
crushes124215133crus_hes
crusted103712753crust_ed
crustier10259533crustier
crustiest112410043crustiest
crustless1155393crustless
crustose1045503crustose
crusts84916543crust__s
draftees12225253draftees
druses75517253drus__es
dusters84918353_dusters
eusteles838043_eusteles
flusters113811493flusters
frisbees13295013frisbees
frisees104411693fris_ees
frosteds12305653frosteds
fruiters11328173fruiters
frustules1244653frustules
frustums1342993frustums
fusees95416403_fus_ees
grantees92510973grantees
gristers94013403gristers
gristles9189203gristles
grunters9359023grunters
gruntles9287233gruntles
gustoes879873_gustoes
hustles103414173_hustles
jousters153210403jousters
justers143815723_justers
justles143311433_justles
listees73416673_listees
lusters73921433_lusters
lustres73013233_lustres
mestees94617753_mestees
mustee83922103_mustee_
musters94522493_musters
ousters74122773_ousters
outsees72616433_outsees
presters103419003presters
prosties101421193prosties
puttees93612913_puttees
rasters74629023_rasters
resees63827483_res_ees
resters74130403_resters
rosters73727533_rosters
rousters84315653rousters
rupees8312573_ru_pees
ruses56136583_rus__es
rushee93818773_rushee_
rushers103816103_rushers
rushes94724363_rus_hes
russets738163_russets
rusted75020923_rust_ed
rustics9810733_rustics
rustier74416363_rustier
rustiest83116803_rustiest
rustle63615413_rustle_
rustled83311323_rustled
rustler73512343_rustler
rustlers8339853_rustlers
rustless83510233_rustless
rusts55026993_rust__s
strutters955673strutters
suttees74114063_suttees
tapsters10318803tapsters
tasters74225643t_asters
tastes64126423t_ast_es
taunters8259263taunters
tautens7317843tau_tens
testee64323303t_estee_
testers74124543t_esters
testes65125823t_est_es
thistles1198233thistles
throstles1265883throstles
thrushes1436523thrus_hes
thrusted1265223thrust_ed
thruster1135793thrust_er
thrustors1244273thrustors
thrusts10226523thrust__s
thuggees1343123thuggees
tipsters10278503tipsters
toasters83912703toasters
toupees938513tou_pees
touses64229673tous__es
tousles74113933tous_les
touters74018333tou_ters
trainees82712063trainees
trashers113013623trashers
trashes104119253tras_hes
trasses74819323tras_ses
treaters83615823treaters
treaties8316983treaties
trees55835763tr___ees
tressels8367653tressels
tresses73719543tres_ses
trestle72611363trestle_
trisceles1145293trisceles
trisemes1036643trisemes
triskeles1344273triskeles
trisomes1039833trisomes
triste63818643trist_e_
tristeza1742933tristeza
tristezas1842743tristezas
trochees132510183trochees
trotters83310233trotters
trousers83910623trous_ers
truces84916333tru__ces
truckers14279003truckers
truckles14319383truckles
trudgens10255143trudgens
trudgers10256853trudgers
trudges9339983tru_dges
trueness838683trueness
trues54925323tru___es
truffes1356773tru_ffes
truffles1485583truffles
trumpets12315573trumpets
trundles9278473trundles
trunnels844513trunnels
truss54916923trus___s
trussed84010013trus_sed
trusser74010253trus_ser
trust55426853trust___
trusteeing1142893trusteeing
trusteeship1661823trusteeship
trustful1144363trustful
trustily11257103trustily
trustiness1036623trustiness
trusting93411653trusting
trustor7238403trust_or
trusty94710113trust__y
truths9449503tru_t_hs
tryste9399583tryst_e_
trysted11428273tryst_ed
tryster10369513tryst_er
trysts9448793tryst__s
tufters10298343t_ufters
turtles72914343t_urtles
tusches1237903t_usches
tushes94319473t_us_hes
tushies10312163t_ushies
tuskers113710033t_uskers
tussehs10395563t_ussehs
tussers74313563t_ussers
tusses64921243t_us_ses
tussles737833t_ussles
tutee5423523t_u_tee_
tutties73216473t_utties
twisters11268173twisters
uruses63616503urus__es
vestees103513163_vestees
wrastles11328933wrastles
wresters112711733wresters
wrestles113310063wrestles

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 Limit1461621937.17020385.2
3Display Results1931930.0802412.5
 (SQL Overall)1786911937.40624127.9
 
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.