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

149 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
trustors826891(None) 
thrustors1244301thrustors
trusters83112261trusters
trustor7238411trustor_
thrusters1245332thrusters
thrustor1144122thrustor_
tractors10312572tractors
traitors8310792traitors
trussers8348282trussers
trustees8339322trustees
truster73114312truster_
trusties82712852trusties
trusts64714432trust__s
trysters11298372trysters
tussors7388772t_ussors
tutors6912332t_u_tors
adjustors1743223adjustors
alastors8311223alastors
aristos7312373aristo_s
arrestors958033arrestors
attestors945753attestors
blusters104413893blusters
bristols1046773bristols
bruiters10329143bruiters
brushers134210573brushers
bursters1038983bursters
busters94724133_busters
castors94919443_castors
clusters102912403clusters
creators102814413creators
cruors838643cru__ors
crushers134010093crushers
crustose1045503crustose
crusts84916543crust__s
curators10311723curators
cursors93910023curs_ors
customs11348263_customs
custos84014313_custo_s
drugstore1142503drugstore
drugstores1252103drugstores
dusters84918363_dusters
eductors1135983eductors
equators1737473equators
erectors103514263erectors
flusters113811503flusters
fruiters11328183fruiters
frustums1342993frustums
grantors93810363grantors
gristers94013413gristers
grunters9359033grunters
gustoes879873_gustoes
jousters153210423jousters
justers143815733_justers
lusters73921443_lusters
musters94522513_musters
nestors73614973_nestors
neustons836833neustons
orators7313823or_ators
ousters74122793_ousters
pastors94119003_pastors
praetors1039833praetors
pressors103212693pressors
presters103419003presters
prestore104217353prestore
prestores114716083prestores
prestos93716083presto_s
pretors9316813pr_etors
proctors12311513proctors
questors17147013questors
raptors94213353_raptors
rasters74629023_rasters
rectors93520523_rectors
resters74130403_resters
restore75822983_restore
restores85222993_restores
rhetors1038513_rhetors
rosters73727553_rosters
rotors64917953_r_otors
rousters84315683rousters
rumors81110403_ru_mors
rushers103816103_rushers
rustics9810733_rustics
rustlers8339853_rustlers
rustles73416413_rustles
rusts55026993_rust__s
stressors955793stressors
strutters955693strutters
suitors73012493_suitors
tapsters10318803tapsters
tasters74225643t_asters
taunters8259273taunters
tautogs875413tau_togs
tensors72712373tens_ors
testers74124543t_esters
testons7313563t_estons
thruster1135793thruster_
thrusts10226523thrust__s
thyristors1652513thyristors
tipsters10278523tipsters
toasters83912723toasters
touters74018353tou_ters
tractor9311343tractor_
traitor7310123traitor_
trashers113013643trashers
treaters83615843treaters
treetops1045463treetops
tremors93711233tr_emors
tressours943893tressours
trestles83012553trestles
trimotors1145143trimotors
trisectors1244463trisectors
tritons73814883tr_itons
trotters83310243trotters
trousers83910633trous_ers
truckers14279013truckers
trudgers10256863trudgers
trueborn1043063trueborn
truss54916923trus___s
trusser74010263trusser_
trusses73813643trus_ses
trust55426853trust___
trusted83412793trust_ed
trustee73514443trust_ee
trusteed9346533trusteed
trustful1144373trustful
trustier8268683trustier
trustiest9239083trustiest
trustily11257103trustily
trusting93411653trusting
trustless955953trustless
trusty94710113trust__y
truths9449503tru_t_hs
tryster10369513tryster_
trystes10419993tryst_es
trysts9448793tryst__s
tufters10298353t_ufters
tumors8810613t_u_mors
turgors836833t_urgors
tuskers113710043t_uskers
tussars7359253t_ussars
tussers74313563t_ussers
tussor6378233t_ussor_
tussore7317283t_ussore
tussores8316533t_ussores
tussurs7356393t_ussurs
tutor5712493t_u_tor_
twisters11268173twisters
varistors1246533varistors
wresters112711733wresters

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621497.75018859.6
3Display Results1491490.0502980.0
 (SQL Overall)1786911498.20621775.7
 
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.