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

109 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
romanced133725(None) 
romance11311081romance_
romancer1247291romancer
romances12310791romances
remanded123011322remanded
remanned11319352remanned
romancers1345732romancers
romanised1247922romanised
romanized2149212romanized
womaned1337212woman_ed
advanced1543313advanced
balanced1356513balanced
bounced123610553bo_unced
bromated1339173broma_ted
chanced154113213_chanced
comanaged1544523comanaged
commanded17136503commanded
commenced18157133commenced
companied1648023companied
danced105315253__danced
demanded13348513demanded
enhanced1436623enhanced
financed1435113financed
fomented1437803fomented
frounced1434493fro_unced
geomancer1443753geomancer
glanced11439233_glanced
gowaned1235763gowan_ed
grimaced1463313grima_ced
groaned9259973gro_an_ed
homaged1497413homa_ged
jounced17337613jo_unced
joyance1944773joyance_
joyances2044413joyances
lanced93717723__lanced
loaned73816293lo_an_ed
maced108528693__ma_ced
maned86634103__man_ed
manned94418643__manned
minced114114913__minced
moaned94514173mo_an_ed
nuanced1036203_nuanced
omened93711003_omen_ed
penanced1338163penanced
pomace123111913poma_ce_
pomaces132712123poma_ces
pomaded13377863poma_ded
pomander1347083pomander
ponced114314813po__nced
pounced123510623po_unced
pranced123714043_pranced
profaned14207973profan_ed
raced87635313r__a_ced
rance75028513r__ance_
rances84625443r__ances
ranched133113603r__anched
rancid9513863r__ancid
ranged84824323r__anged
ranked114620743r__anked
ranted74324703r__anted
recaned102817203recan_ed
recanted112513513recanted
refaced133713573refa_ced
refenced1438993refenced
rehanged1357833rehanged
relaced103517213rela_ced
relanded102410463relanded
remailed112411403remailed
remained112412893remained
remand95618963reman__d
remapped1534913remapped
remarked15209243remarked
rematched1745223rematched
remated103522473rema_ted
remended123010393remended
reminded123411523reminded
reminted113615083reminted
roached133211833ro_ached
roadbed1134793ro_adbed
roamed95215093ro_a_med
roared75015393ro_a_red
roasted83912663ro_asted
roband92310723roban__d
romaine9512123romaine_
romaines10512523romaines
roman75424823roman___
romancing1446043romancing
romanise10312133romanise
romanises11311573romanises
romanize19311013romanize
romanizes20310933romanizes
romano84912943roman__o
romanos94311483roman_os
romans84620243roman__s
romantic1249243romantic
romped114513653rom__ped
rosacea944713rosa_cea
rosined84911903rosin_ed
rotated82715293rota_ted
rounded93013503ro_unded
solaced102911063sola_ced
sonance9310313sonance_
sonances10310263sonances
tranced104414173_tranced
trounced1135033tro_unced
unmanned11268603unmanned
valanced1475463valanced
womanised1545753womanised
womanized2447043womanized

Search took 10 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.406440125.6
2DLD Change Limit1461621099.42015516.1
3Display Results1091090.0502180.0
 (SQL Overall)1786911099.87618093.5
 
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.