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

218 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
tourney103627(None) 
journey1734871journey
tourneys1134011tourneys
bourne83714092bourne_
bournes93615022bournes
gurney10429412_gurney
journeys1843202journeys
mourned1037762mourned
mourner938092mourner
toney86027412to__ney
toured74216152tour_ed
tourer64115072tour_er
tourneyed1342322tourneyed
turkey1337762t_urkey
turned73914472t_urned
turner63914612t_urner
turnery10357422t_urnery
turnkey1433012t_urnkey
attorney1173723attorney
barney115314453_barney
blarney12174763blarney
boloney1247763boloney
boney105227313bo__ney
borne77926793bo_rne_
bouncy13409073bou_ncy
bounty113411073bou_nty
bourn75518483bourn__
bourns84114063bourn_s
bourree91311343bourree
bourse84414333bourse_
bourses94014303bourses
burley114715753_burley
burned95818963_burned
burner83819203_burner
burnet84326173_burnet
carney115315703_carney
churned13358373churned
churner12298343churner
chutney1533823chutney
cockney1835873cockney
coney105932883co__ney
cornea84018923co_rnea
corned95224523co_rned
cornel84020053co_rnel
corner84625623co_rner
cornet84436733co_rnet
corny106023273co_rn_y
county114313323cou_nty
courier93617893courier
course85117783course_
coursed104113603coursed
courser94114803courser
courses94218893courses
courted103514923courted
courter94516483courter
courtesy1364973courtesy
courtly1256923courtly
curvey144111843_curvey
dourer74215273dour_er
dourine8311453dourine_
dourines9311373dourines
dourly103210433dour_ly
dourness947683dourness
durned84113173_durned
gooney106612313go_oney
gourde8107933gourde_
gourdes9109383gourdes
gourmet1059203gourmet
gurnet74920873_gurnet
gurneys11406463_gurneys
honey115629913ho__ney
horned105718703ho_rned
hornet94926433ho_rnet
horny115619623ho_rn_y
horsey125115403ho_rsey
hourly12369623hour_ly
hurley125012523_hurley
inurned8328053inurned
jouncy18336203jou_ncy
journal1484963journal
journeyed2041983journeyed
journeyer1942023journeyer
journo13135293journ_o
journos14134943journos
koruny1334443korun_y
kouprey1652793kouprey
looney94712413lo_oney
loungy10476833lou_ngy
loured74617403lour_ed
loury85716753lour__y
money104826843mo__ney
mourn77215013mourn__
mourners1036913mourners
mourns84111013mourn_s
mousey115216193mou_sey
murrey114312263_murrey
ornery938463_o_rnery
ourie54027303_ourie_
porny106020193po_rn_y
poured95116743pour_ed
pourer84516043pour_er
purvey14559573_purvey
sorned74820043so_rned
sorner64720393so_rner
source8410673source_
sourced1038453sourced
sources9312173sources
soured74921863sour_ed
sourer63620213sour_er
sourly93612213sour_ly
sourness839543sourness
spurned10339263spurned
spurner9269653spurner
spurrey12307813spurrey
stoney96217353sto__ney
storey95217613sto_r_ey
stoure64814943stour_e_
stoures74614163stour_es
stourie7469353stourie_
stoury9529943stour__y
surrey94414583_surrey
survey124111673_survey
taurine7311363taurine_
taurines8310553taurines
tawney12338233t_awney
terne56426153t_erne_
ternes65422903t_ernes
thorned11479403thorned
thorny12509843thorn_y
tokened1236393tokened
tolane64316583tolane_
tolanes74216313tolanes
toluene736463toluene_
toluenes836763toluenes
tone46953743to__ne_
toned65435343to__ned
toner55336243to__ner
tones56048663to__nes
tonne54921433to_nne_
tonner64819203to_nner
tonnes65320853to_nnes
tony75635153to__n_y
torchy14549533to_rchy
tore47359323to_r_e_
tores55352673to_r_es
tories65435883to_ries
torn46044253to_rn__
torrefy1353353torrefy
torrent7313413torrent
torrify1335013torrify
torse55833333to_rse_
torses64727953to_rses
torte55431703to_rte_
torten65314353to_rten
tortes64826053to_rtes
tory75840543to_r__y
touche114916173touche_
touched134914963touched
toucher124814353toucher
touches125118343touches
touchy145010503tou_chy
toughed123511693toughed
toughen11329203toughen
tougher114210983tougher
toughly14487433toughly
toughy135911073tou_ghy
toupee8316133tou_pee
toupees938513toupees
tour45530383tour___
touraco945363touraco
tourers73512743tourers
touring82915193touring
tourings9277373tourings
tourism939423tourism
tourist7313203tourist
touristy1144513touristy
tournedos1042533tournedos
tourneying1442533tourneying
tours55325893tour__s
touse55430673tou_se_
toused74122013tou_sed
touses64229673tou_ses
tousle64514653tousle_
tousled84710363tousled
tousles74113933tousles
touted74419743tou_ted
touter63821033tou_ter
touzle15429003touzle_
touzled17367153touzled
touzles16359223touzles
townee92815213to_wnee
towny116114493to_wn_y
toxine133114123toxine_
toxines142912263toxines
trey77228793t__r_ey
truancy1244993truancy
trunnel745403trunnel
tune45635863t_u_ne_
tuned64622313t_u_ned
tuner56022683t_u_ner
tunes55332193t_u_nes
tunned74014493t_unned
tunnel64310633t_unnel
tunny86515033t_u_nny
tureen63312723t_ureen
turfed103110963t_urfed
turfy114315403t_ur_fy
turkeys1434523t_urkeys
turn46330383t_urn__
turners73912893t_urners
turnip836593t_urnip
turnkeys1542123t_urnkeys
turnon638193t_urnon
turns55623233t_urn_s
turnup835093t_urnup
turret63121853t_urret
turves94212693t_urves
yourn87512773yourn__

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.406440125.6
2DLD Change Limit1340272186.14021828.5
3Display Results2182180.0762868.4
 (SQL Overall)1786912186.62226984.4
 
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.