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

152 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
journey173487(None) 
journeys1843201journeys
tourney1036271tourney
bourne83714092bourne_
bournes93615022bournes
gurney10429412_gurney
jouncy18336202jou_ncy
journal1484962journal
journeyed2041982journeyed
journeyer1942022journeyer
journo13135292journ_o
journos14134942journos
mourned1037762mourned
mourner938082mourner
tourneys1134012tourneys
adjourned1842063adjourned
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
courier93617873courier
course85117773course_
coursed104113603coursed
courser94114803courser
courses94218893courses
courted103514913courted
courter94516463courter
courtesy1364973courtesy
courtly1256913courtly
curvey144111843_curvey
dourer74215273dour_er
dourine8311443dourine_
dourines9311363dourines
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
jarvey19135403j_arvey
jaunty16388513jau_nty
jeepney1942093jeepney
jersey1636333j_ersey
jitney16304623j_itney
joannes1436243joannes
jockey22408033jo_ckey
joey145719333jo___ey
johnny1932193jo_hnny
joined144613073jo_ined
joiner134114133jo_iner
joinery17366593jo_inery
jokey195014693jo__key
jones125028183jo__nes
jouked18568153jou_ked
joule124918203jou_le_
joules134116823jou_les
jounce153310733jou_nce
jounced17337613jounced
jounces16369853jounces
journaled1742673journaled
journals1574353journals
journeyers2051653journeyers
journeying2142413journeying
journeyman2251333journeyman
journeymen2251743journeymen
jousted15339143jousted
jouster143311043jouster
junky194513233j_u_nky
jurel124516333j_ur_el
juried144212443j_uried
juries134120633j_uries
jury146719593j_ur__y
koruny1334443korun_y
kouprey1652793kouprey
looney94712403lo_oney
loungy10476833lou_ngy
loured74617403lour_ed
loury85716753lour__y
money104826843mo__ney
mourn77215013mourn__
mourners1036913mourners
mourns84111013mourn_s
mousey115216193mou_sey
murrey114312253_murrey
ornery938463_o_rnery
ourie54027293_ourie_
porny106020193po_rn_y
poured95116743pour_ed
pourer84516043pour_er
purvey14559573_purvey
sojourned1761493sojourned
sojourner1661713sojourner
sorned74820043so_rned
sorner64720383so_rner
source8410673source_
sourced1038453sourced
sources9312173sources
soured74921863sour_ed
sourer63620213sour_er
sourly93612203sour_ly
sourness839543sourness
spurned10339263spurned
spurner9269653spurner
spurrey12307803spurrey
surrey94414573_surrey
survey124111663_survey
toney86027413to__ney
toured74216153tour_ed
tourer64115073tour_er
tourneyed1342323tourneyed
turkey1337763_turkey
turned73914473_turned
turner63914613_turner
turnery10357423_turnery
turnkey1433013_turnkey
yourn87512773yourn__

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271528.06316622.5
3Display Results1521520.0463304.3
 (SQL Overall)1786911528.26521620.2
 
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.