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

159 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
romances1231079(None) 
romance11311081romance_
romanced1337251romanced
romancer1247291romancer
romancers1345711romancers
joyances2044412joyances
pomaces132712122poma_ces
rances84625442r__ances
romaines10512512romaines
romanise10312132romanise
romanises11311562romanises
romanizes20310932romanizes
romanos94311472roman_os
romans84620242roman__s
sonances10310262sonances
adamances1445033adamances
advances1445613advances
arrogances1344243arrogances
balances1279973balances
boraces113716853bora_ces
boranes93720403boran_es
botanies10312853botanies
bounces113813683bo_unces
brisances1345843brisances
bromates12413133broma_tes
bromines122514253bromin_es
buoyances1643353buoyances
chances145218093_chances
comakes154413643coma_kes
comanages1446533comanages
comates114123633coma_tes
commences17139573commences
companies15311793companies
dances95120653__dances
domaines11611063domaines
dominances1545683dominances
domines102918973domin_es
dominies113513193dominies
dominoes11349043dominoes
dormancies1565413dormancies
durances1158683durances
enhances1339293enhances
fiances12310673_fiances
finances1338653finances
fromages1437073froma_ges
frounces1336183fro_unces
geomancer1443753geomancer
geomancers1542953geomancers
geomancies1545743geomancies
glances104113143_glances
grimaces1355383grima_ces
hances115621283__hances
hogmanes1446773hogman_es
homages131011583homa_ges
homines123518643homin_es
hominies133012953hominies
joannes1436243jo_annes
johannes1842943johannes
jounces16369853jo_unces
joyance1944773joyance_
kokanees1143033kokanees
lances84824103__lances
maces97139963__ma_ces
manches143818623__manches
manes76648953__man_es
manges94628943__manges
manses84225513__manses
mantes84430783__mantes
minces104420803__minces
nances83618643__nances
nomarchs1543903nomarchs
nominees1037363nominees
nonces84418833no__nces
nondances1247803nondances
nuances938523_nuances
oranges84215333_oranges
ordnances1244753ordnances
ounces83617773_o_unces
penances12312443penances
pomace123111913poma_ce_
pomades123711733poma_des
pomander1347083pomander
pomanders1436223pomanders
ponces104720843po__nces
portances1349833portances
potences12710693potences
pounces114113893po_unces
prances113618773_prances
profanes132311573profan_es
promines123018803promin_es
propanes122415823propan_es
provinces1646853provinces
pyromancies2054873pyromancies
races74943243r__a_ces
radiances1247693radiances
rampancies1644043rampancies
rance75028513r__ance_
ranches123620113r__anches
ranees64623963r__anees
ranges73826923r__anges
ratanies8312923ratanies
recanes93222263recan_es
refaces123216743refa_ces
refences13311843refences
relaces93420883rela_ces
reliances1139623reliances
remakes134116173rema_kes
remanded123011323remanded
remands104914883reman_ds
remanences1446623remanences
remanned11319353remanned
remans84823003reman__s
rematches1636653rematches
remates93827103rema_tes
resonances1246873resonances
revanches1746253revanches
riddances1343893riddances
roaches123616213ro_aches
roadies83317433ro_adies
roans54926443ro_an__s
robands10219853roban_ds
romaine9512123romaine_
romajis1635903roma_jis
roman75424823roman___
romancing1446043romancing
romanised1247923romanised
romanize19311013romanize
romanized2149213romanized
romano84912943roman__o
romantic1249233romantic
romantics1346773romantics
romaunts1043693romaunts
rosacea944713rosa_cea
rosaceas1043723rosa_ceas
rosaries8312783rosaries
rotaries8315693rotaries
rotates72819773rota_tes
rowans95715343rowan__s
rubaces1139303ruba_ces
seances93015343_seances
solaces93116133sola_ces
somans84619303soman__s
sonance9310313sonance_
stances93715963_stances
tolanes74216313tolan_es
tomans85419133toman__s
tomatoes1038603tomatoes
trances93919643_trances
trounces1037053tro_unces
usances967373_usances
valances1398763valances
voidances1544473voidances
womaned1337213woman_ed
womanise1348733womanise
womanises1448063womanises
womanizes2347993womanizes
womanless1443383womanless
womanness1444473womanness
womans114613653woman__s

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621597.14320462.3
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.35924282.0
 
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.