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

67 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
preservers1511569(None) 
preserver14127011preserver_
preserves14109071preserve_s
reservers12138101_reservers
deservers13107292_deservers
preferrers1542982preferrers
presenters1239862presenters
preserve13108802preserve__
preserved15107562preserve_d
presurveys1842542presurveys
reserver11119632_reserver_
reserves111011982_reserve_s
berserkers1642953berserkers
conservers1547683conservers
deserters10129983_deserters
deserver12118383_deserver_
deserves12109893_deserve_s
observers1443973_observers
perceivers1743893perceivers
persevere1443993perse_vere
perseveres1543403perse_veres
perverters1544963perverters
pesterers112510463p_ester_ers
preavers13910263pr__eavers
preeners102712813pre_e_ners
preferrer1443893preferrer_
preheaters1557193preheaters
premerger1444903premerger_
preorders1235403pre_orders
preparers13197673prepar_ers
presagers1236943pres_agers
presbyters1743183presbyters
prescreens1443843prescreens
prescribers1793153prescribers
presences132113793presence_s
presentees1247923presentees
presenter11311643presenter_
preservice1744493preservice
preserving1637363preserving
presiders1248213pres_iders
presolves1456533presolve_s
pressers103215023pres__sers
presters103419003pres__ters
prestress1138133prestr_ess
presumers1336373pres_umers
presurgery1642783presurgery
presurvey1744603presurve_y
pretenders1345243pretenders
preventers1547393preventers
priseres10310823priser_e_s
receivers1436363_receivers
referrers12125373_referrers
resellers9299933_resellers
reserve101011203_reserve__
reserved121010583_reserve_d
reservoirs1351993_reservoirs
resetters9129463_resetters
resilvers12306503_resilvers
resolvers12297833_resolvers
resorters939693_resorters
resurveys1542683_resurveys
reverers113113153_rever_ers
reversers12298483_reversers
reverters122710433_reverters
servers103214833___servers
timeservers1651613timeservers
unreserves1343243unreserve_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 Filter1786911406030.423422437.4
2DLD Change Limit140603677.29619271.2
3Display Results67670.0302233.3
 (SQL Overall)178691677.74923059.9
 
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.