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

227 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
tractor931133(None) 
tractors10312561tractors
traitor7310121traitor
actor71116072__actor
attractor1145822attractor
coactor1139122coactor
detractor12147212detractor
enactor938032enactor
erector93513802erector
exactor1636622exactor
extractor1846722extractor
factor11911452_factor
fractur12135562fractur
grantor84010932grantor
orator6314532ora_tor
praetor938972praetor
proctor11310432proctor
raptor83912822_raptor
reactor93011652reactor
rector84019742_rector
retractor11218512retractor
tracer84820232trac_er
tracker133515172tracker
tract75635712tract__
traction10412682traction
tracts85019072tract_s
traditor945942traditor
traitors8310792traitors
trustor7238412trustor
varactor1345682varactor
abator84512713aba_tor
abstractor1444383abstractor
actors81016763__actors
adaptor1034943adaptor
aerator7314843aera_tor
alastor739653alastor
attracter1146093attracter
attractors1245843attractors
bracer104620583brac_er
bracero11428743bracero
bract96332723bract__
bracted12410933bracted
bracts105617773bract_s
cantor85621523_cantor
captor104914603_captor
castor84418533_castor
chantor123710313chantor
coactors1239473coactors
cofactor1545753cofactor
contractor1449073contractor
cracker153114173cracker
crafter124111333crafter
crater85026643cra_ter
craton84517193cra_ton
creator93714433creator
curator9312213cura_tor
detractors13147293detractors
director1147773director
doctor938993_doctor
drafter11449423drafter
eductor1035863eductor
ejector16378603ejector
elector93313253elector
enactors1038453enactors
enactory1346143enactory
erecter93113393erecter
erectors103514253erectors
evictor12346363evictor
exacter1637403exacter
exactors1737013exactors
extractors1946423extractors
factors12912123_factors
factory15108343_factory
fractal1237623fractal
fracted1339373fracted
fracti1139963fract_i
fraction1359483fraction
fracture13147123fracture
fracturs13146313fracturs
fractus12146593fractus
fraktur14153033fraktur
frater94520593fra_ter
functor1235203functor
gator64416033_ga_tor
grafter114211153grafter
granter84117133granter
grantors93810353grantors
grater74625443gra_ter
gyrator1135713gyra_tor
hector113312653_hector
impactor14265003impactor
infractor1465943infractor
irater65218353ira_ter
krater104014313kra_ter
lector83514983_lector
lictor83610853_lictor
locator93110423locator
nitrator849553nitra_tor
nonactor1047773nonactor
orators7313823ora_tors
oratory1039403ora_tory
parachor1546653parachor
pastor84817483_pastor
practic13312243practic
praetors1039833praetors
prater84825353pra_ter
pretor8315743pr_etor
proctors12311513proctors
protractor1446263protractor
racer75233023_rac_er
racier85120973_racier
racker124824553_racker
racon75422143_rac_on
racoon83814473_racoon
rafter94517583_rafter
ragtop936683_ragtop
rancor8810373_rancor
ranter63826823_ranter
raptors94213353_raptors
raster64731443_raster
rater54943283_ra_ter
rato45436973_ra_to_
ratos55528763_ra_tos
ratter64326313_ratter
ratton64116123_ratton
razor143012603_ra_zor
reactors103212283reactors
realtor73611353realtor
recto74520803_recto_
rectors93520513_rectors
rectory123512723_rectory
rectos85718783_rectos
redactor1147023redactor
refractor14156323refractor
retractors12158583retractors
rhetor938063_rhetor
rotor55519733_r_otor
sartor6313873_sartor
sector83415923_sector
stator64015483sta_tor
straiter8311783straiter
stricter1039423stricter
tabor75518393t_a_bor
tacker124224503t_acker
taco67031353t_ac_o_
tacos77023553t_ac_os
tact67349033t_act__
tactic10612753t_actic
taction93213023t_action
tacts76524123t_act_s
tailor63412503t_ailor
tanto55724943t_anto_
tartar63214753t_artar
tarter64023563t_arter
taster64930573t_aster
tatar56122063t_a_tar
tater54138613t_a_ter
tatter64024573t_atter
tattoo6310973t_attoo
tauter64318023t_auter
tautog765713t_autog
teacher123714833teacher
thrustor1144123thrustor
tictoc1036003t_ictoc
titrator858543titra_tor
toaster74414463toaster
trace75829613trac__e
traced94821583trac_ed
tracers94917843tracers
tracery12399793tracery
traces85329933trac_es
trachea12311673trachea
trachle12311853trachle
trachoma15116623trachoma
tracing103720153tracing
track114823013trac__k
tracked143716133tracked
trackers143512853trackers
tracks124818843trac_ks
tractate10411003tractate
tractile10311073tractile
tractions11511623tractions
tractive13310043tractive
trader75218763tra_der
trailer73015393trailer
trainer73316793trainer
trait56940843trait__
traits65121983trait_s
trajectory2252563trajectory
tramcar1135593tramcar
tramper113812163tramper
transactor1265173transactor
transom948823transom
trapdoor1143653trapdoor
trapper113912803trapper
trapt76433393trapt__
trasher104416133trasher
trattoria944753trattoria
trattorie944963trattorie
trawler104011903trawler
treater74219833treater
treetop945523treetop
tremor84210393tr_emor
tricker134615523tricker
tricolor10115833tricolor
tricorn937963tric_orn
tricot8317753tric_ot
tricots9311563tricots
trimotor1044813trimotor
trisector1144323trisector
triter65120593tr_iter
triton63914893tr_iton
trocar848773troc_ar
trochar1257073trochar
trotter73312253trotter
trucker134010733trucker
truster73114313truster
trustors8268913trustors
tryster10369513tryster
turaco839453turac_o_
turacos938643turac_os
turacou945513turac_ou
tutor5712493t__utor
varactors1446393varactors
vector113212063_vector
viator93211833via_tor
victor113210673_victor

Search took 7 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.1561145455.1
2DLD Change Limit1340272276.40620922.1
3Display Results2272270.0932440.9
 (SQL Overall)1786912276.65526850.6
 
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.