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

92 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
romancer124729(None) 
romance11311081romance_
romanced1337251romanced
romancers1345731romancers
romances12310791romances
geomancer1443752geomancer
pomander1347082pomander
advancer1443483advancer
balancer1246603balancer
bouncer113811333bo_uncer
cancer104220923__cancer
chancer144215633_chancer
chiromancer2052943chiromancer
colander1139033colander
comaker153410603coma_ker
comanager1444533comanager
commander16127403commander
commencer17147803commencer
dancer94817613__dancer
demander12238723demander
domineer1146273domineer
enhancer1346683enhancer
fomenter1339263fomenter
geomancers1542953geomancers
glancer103710073_glancer
grimacer1363963grima_cer
groaner82510133gro_an_er
homager13107853homa_ger
humaner12257663human_er
joyance1944773joyance_
joyances2044413joyances
lancer84319973__lancer
loaner64416503lo_an_er
macer912126943__ma_cer
manger94325003__manger
manner84020513__manner
mincer104017363__mincer
moaner84415113mo_an_er
necromancer1752553necromancer
nondancer1245593nondancer
pomace123111913poma_ce_
pomaces132712123poma_ces
pomanders1436223pomanders
pouncer113511233po_uncer
prancer113613383_prancer
precancer1547093precancer
profaner13197943profan_er
racer75233023r__a_cer
rance75028513r__ance_
rances84625443r__ances
rancher123013633r__ancher
rancor8810373r__ancor
ranger73925523r__anger
ranker105021903r__anker
ranter63826823r__anter
recanter101913153recanter
remainder1244683remainder
remaker133813173rema_ker
remanded123011323remanded
remanned11319353remanned
remarker14178493remarker
remaster10311473remaster
reminder113110513reminder
roamer84715163ro_a_mer
roarer63914333ro_a_rer
roaster74116663ro_aster
romaine9512123romaine_
romaines10512523romaines
roman75424823roman___
romancing1446043romancing
romanise10312133romanise
romanised1247923romanised
romanises11311573romanises
romanize19311013romanize
romanized2149213romanized
romanizes20310933romanizes
romano84912943roman__o
romanos94311483roman_os
romans84620243roman__s
romantic1249233romantic
romper104213683rom__per
ropedancer15132523ropedancer
rosacea944713rosa_cea
rounder83514603ro_under
solacer93011103sola_cer
solander948123solander
sonance9310313sonance_
sonances10310263sonances
trouncer1035443tro_uncer
womaned1337213woman_ed
womanizer2346243womanizer
womanlier1443323womanlier

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.250714764.0
2DLD Change Limit146162929.09616068.8
3Display Results92920.0303066.7
 (SQL Overall)178691929.37619058.3
 
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.