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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
romancing144604(None) 
remanding132211142remanding
remanning12229032remanning
romanising1346582romanising
romanizing2248252romanizing
womaning1437642woman_ing
advancing1643063advancing
balancing1435783balancing
bouncing13318773bo_uncing
bromating1439183broma_ting
chancing162810283_chancing
comaking1739993coma_king
comanaging1644323comanaging
commanding1845923commanding
commencing1946183commencing
companying2044813companying
dancing113611563__dancing
demanding14237923demanding
enhancing1545823enhancing
financing1544073financing
fomenting1537233fomenting
frouncing1534763fro_uncing
glancing1247063_glancing
grimacing1544033grima_cing
groaning102410283gro_an_ing
homaging1536613homa_ging
jouncing18336853jo_uncing
lancing103314123__lancing
loaning83614833lo_an_ing
macing114221553__ma_cing
manning103616383__manning
mincing123314333__mincing
moaning103714443mo_an_ing
omening10310103_omen_ing
penancing1436343penancing
pomading1437423poma_ding
poncing122913583po__ncing
pouncing13318883po_uncing
prancing132612163_prancing
profaning1537293profan_ing
racing95030533r__a_cing
ranching141712043r__anching
ranging94120263r__anging
ranking124320883r__anking
ranting84025413r__anting
recaning111416693recan_ing
recanting122414823recanting
refacing142512813refa_cing
refencing15188853refencing
rehanging1437563rehanging
relacing112516043rela_cing
relanding112110923relanding
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remapping1635023remapping
remarking1638893remarking
rematching1844913rematching
remating112322423rema_ting
remending132311313remending
reminding132311543reminding
reminting122315103reminting
roaching143210433ro_aching
roaming103215793ro_a_ming
roaring82916003ro_a_ring
roasting93012703ro_asting
romaine9512123roma__ine
romance11311083romanc__e
romanced1337253romanc_ed
romancer1247293romanc_er
romancers1345733romancers
romances12310793romanc_es
romanise10312133roman_ise
romanize19311013roman_ize
romantic1249243romanti_c
romantics1346783romantics
romping123113033rom__ping
ropedancing1751713ropedancing
rosining92411423rosin_ing
rotating92614553rota_ting
rounding102812283ro_unding
solacing11310133sola_cing
trancing112812023_trancing
trouncing1235153tro_uncing
unmanning1245873unmanning
valancing1544743valancing
womanising1645013womanising
womanizing2546103womanizing
womankind1942323womankind

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 Filter1786911486410.440406115.9
2DLD Change Limit148641897.86018911.1
3Display Results89890.0302966.7
 (SQL Overall)178691898.33021451.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.