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

171 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
trustor723841(None) 
thrustor1144121thrustor
truster73114311truster
trustors8268911trustors
thruster1135792thruster
thrustors1244302thrustors
tractor9311342tractor
traitor7310122traitor
trusser74010262trusser
trust55426852trust__
trusted83412792trusted
trustee73514442trustee
trusters83112262trusters
trustier8268682trustier
trusts64714432trust_s
trusty94710112trust_y
tryster10369512tryster
tussor6378232t_ussor
tutor5712492t_u_tor
adjustor1643123adjustor
alastor739673alastor
aristo6414033aristo_
aristos7312373aristos
arrestor847653arrestor
attestor845463attestor
bluster94215313bluster
bristol937043bristol
bruiter93710633bruiter
brusher123813003brusher
brusker13437853brusker
burster9310293burster
buster84726493_buster
castor84418533_castor
cluster94013333cluster
creator93714443creator
cruor7310453cru__or
crusher124412323crusher
crust75827663crust__
crustal939023crustal
crusted103712753crusted
crustier10259533crustier
crustose1045503crustose
crusts84916543crust_s
crusty114911343crust_y
curator9312213curator
cursor84110293curs_or
custom104010273_custom
custos84014313_custos
drugstore1142503drugstore
duster74919723_duster
eductor1035863eductor
equator1637483equator
erector93513813erector
fluster103913063fluster
fruiter10309683fruiter
frusta937453frust_a
frustum1243953frustum
grantor84010943grantor
grister83915413grister
grunter83110783grunter
gusto65414643_gusto_
jouster143311043jouster
juster134617013_juster
luster64023673_luster
muster84724523_muster
nestor63713423_nestor
neuston736083neuston
orator6314533or_ator
ouster64223733_ouster
pastor84817483_pastor
praetor938973praetor
pressor93512883pressor
prester93519623prester
presto84216203presto_
prestore104217353prestore
prestos93716083prestos
pretor8315753pr_etor
proctor11310433proctor
prutot8311823pru_tot
questor16146633questor
raptor83912823_raptor
raster64731443_raster
rector84019753_rector
rester63832433_rester
restore75822983_restore
rhetor938063_rhetor
roster64329083_roster
rotor55519733_r_otor
rouster73517083rouster
rumor71011323_ru_mor
rusher94019653_rusher
rust45544913_rust__
rusted75020923_rusted
rustic8712673_rustic
rustier74416363_rustier
rustle63615413_rustle
rustler73512343_rustler
rusts55026993_rust_s
rusty85221053_rust_y
stressor875543stressor
strutter846503strutter
suitor63311053_suitor
tapster9299273tapster
taster64930573t_aster
taunter73111453taunter
tauter64318023tau_ter
tautog765713tau_tog
tensor63812673tens_or
tester64227153t_ester
teston6313303t_eston
thrust91911893thrust__
thrusted1265223thrusted
thrusters1245333thrusters
thrusts10226523thrust_s
thyristor1542363thyristor
tipster9299053tipster
toaster74414463toaster
touter63821033tou_ter
tractors10312573tractors
traditor945943traditor
traitors8310793traitors
trasher104416133trasher
treater74219833treater
treetop945523treetop
tremor84210403tr_emor
tressour844573tressour
trestle72611363trestle
trimotor1044813trimotor
trisector1144323trisector
triste63818643trist_e
triter65120593tr_iter
triton63914893tr_iton
trotter73312253trotter
trouser73812473trous_er
trucker134010733trucker
trudger9338733trudger
trueborn1043063trueborn
truer54916643tru__er
truest64816193truest__
truistic1046903truistic
truss54916923trus__s
trussed84010033trussed
trussers8348283trussers
trusses73813643trusses
trusteed9346533trusteed
trustees8339323trustees
trustful1144373trustful
trusties82712853trusties
trustily11257103trustily
trusting93411653trusting
truth85214153tru_t_h
truths9449503tru_ths
tryst84716223tryst__
tryste9399583tryst_e
trysted11428273trysted
trysters11298373trysters
trystes10419993trystes
trysts9448793tryst_s
tufter9319933t_ufter
tumor71110693t_u_mor
turgor736863t_urgor
tusker104212193t_usker
tussar6369543t_ussar
tusser64615833t_usser
tussore7317283t_ussore
tussors7388773t_ussors
tussur6357293t_ussur
tutors6912333t_u_tors
twister10308953twister
varistor1146393varistor
wrester102812413wrester

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271716.61020276.4
3Display Results1711710.0762250.0
 (SQL Overall)1786911717.10625146.5
 
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.