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

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

99 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
conservator165637(None) 
conservators1755971conservators
conservatory2054751conservatory
consecrator1546382consecrator
conservation1749402conservation
conservatoire1862762conservatoire
congregator1554113congregator
consecrators1656053consecrators
consecratory1954543consecratory
conservancy2154293conservancy
conservations1849093conservations
conservatism19104953conservatism
conservative20106993conservative
conservatize26125503conservatize
conservatoires1962183conservatoires
conservatorial1972243conservatorial
conservatories1962543conservatories
conserver1448723conserv__er
conspirator1555653conspirator
constrictor1596123constrictor
constructor1576523constructor
consummator17134053consummator
convertor1448783conver__tor
cooperator1446833cooper_ator
enervator1245523_en_ervator
observatory1952623_observatory
castrator1147644c_astr_ator
coacervate1763724coacervat_e
coacervates1883594coacervates
coacervation1964274coacervation
cocreator1346964co__creator
cocurator1347574co_cur_ator
cogenerator1454174cogener_ator
commentator1755274commentator
comparator1665804compar_ator
compensator1754674compensator
compurgator1882824compurgator
concentrator1655334concentrator
concerto123311614concer__to_
concertos132711134concer__tos
conciliator1595594conciliator
condemnatory2052864condemnatory
conferva1644434conferva___
confervae1745144conferva__e
conferval1745564conferva__l
confervas1744824conferva__s
confirmatory2253574confirmatory
confiscator18113744confiscator
congregators1653834congregators
connector1347924conne__ctor
consecrate1448434consecrat_e
consecrated1646914consecrated
consecrates1548394consecrates
consecration1649784consecration
consenter11312494conse__nter
conservational1955344conservational
conservatisms2083534conservatisms
conservatives2195194conservatives
conservatized28113604conservatized
conservatizes27114454conservatizes
conservatorship2571694conservatorship
conserve1339934conserv___e
conserved1538854conserv__ed
conservers1547684conserv_ers
conserves14311194conserv__es
conserving1639764conserv_ing
consolatory1684964cons_olatory
consolidator1553284consolidator
conspirators1655534conspirators
constellatory1862594constellatory
consternate1355124consternat_e
consternated1554124consternated
consternates1455054consternates
consternation15106364consternation
constrictors1676014constrictors
constructors1676474constructors
consultor1176474cons__ultor
consummators18134024consummators
consummatory21133494consummatory
contemplator1853734contemplator
continuator1386014continuator
contractor1449074con_tractor
convector1648084conve__ctor
conversation1747804conversation
converter14311014conver__ter
convertors1549134conver__tors
cooperators1547004cooper_ators
corporator1446944corpor_ator
correlator1245694corre_lator
dissertator1253074dissertator
enervators1345704_en_ervators
generator1067594gen_er_ator
moderator12106544mo_der_ator
nonsecretor1352904nonsecretor
observation1665064_observation
operator10310094_o_per_ator
servitor1145064___servitor
tolerator956754to_ler_ator
venerator1247264ven_er_ator

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 Filter1786911488190.420425454.8
2DLD Change Limit148819999.06316420.5
3Display Results99990.0462152.2
 (SQL Overall)178691999.52918752.3
 
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.