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 “ranches” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
ranches12362011(None) 
branches153613801branches
cranches153114541cranches
manches143818621manches
rances84625441ranc_es
ranched133113601ranched
rancher123013631rancher
ranchers133311791ranchers
ranchos123911391ranchos
ratches123620461ratches
raunches1368051raunches
tranches132915511tranches
aches106132292_a_ches
anchos114214892_anchos
arches114822042_arches
baches135426942ba_ches
batches144019612batches
benches143918602benches
blanches153311602blanches
braches144621222bra_ches
branched163210452branched
brunches153710452brunches
bunches144116032bunches
caches137926912ca_ches
canchas143212402canchas
catches144320762catches
cinches144215772cinches
conches144019812conches
cranched163210412cranched
cratches153012542cratches
craunches1655722craunches
crunches153711352crunches
dances95120652danc_es
drenches14309802drenches
dunches133312582dunches
fancies124018782fancies
finches153914192finches
frenches163311632frenches
ganaches1437412ganaches
grinches1436942grinches
hances115621282hanc_es
hatches153420272hatches
haunches1656962haunches
hunches153913462hunches
inches114419672_inches
kenches163912272kenches
laches116528342la_ches
lances84824102lanc_es
larches124416442larches
latches123320122latches
launches1387902launches
lunches124115442lunches
lynches15378872lynches
maches134827232ma_ches
manche133515102manche_
manchet143317772manchet
manchets15269572manchets
marches143921172marches
matches143219782matches
munches144215792munches
naches114622412na_ches
nances83618642nanc_es
nancies93516842nancies
oraches124216472ora_ches
painches1588912painches
panaches15310282panaches
panoches1548122panoches
parches143720002parches
patches143320382patches
paunches1568172paunches
pinches144117932pinches
planches153111862planches
prances113618772pranc_es
punches144816132punches
races74943242ra_c_es
rachet115028972ra_chet
rachets124516832ra_chets
rachis114017652ra_chis
rance75028512ranc_e_
ranch105019792ranch__
ranchero13277422ranchero
rancheros14255792rancheros
ranchless1444452ranchless
ranchmen1545832ranchmen
rancho114310852ranch_o
rancors9811372rancors
randies84225662randies
ranees64623962ran_ees
ranges73826922ran_ges
rankles113114542rankles
raphes115117452ra_phes
rashes95330152ra_shes
ratchet124218332ratchet
ratchets133110262ratchets
reaches123423202reaches
retches123318512retches
revanches1746252revanches
riches115022082r_iches
roaches123616212roaches
rotches123515702rotches
rouches124217892rouches
ruches114819582r_uches
stanches132312792stanches
taches114224172ta_ches
tenches123515522tenches
trances93919642tranc_es
tranche123312222tranche_
trenches133512602trenches
watches153017372watches
wenches152914132wenches
winches154714372winches
wrenches163210232wrenches

Search took 5 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711123.81328237.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911123.99944683.9
 
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.