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

91 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
separating134864(None) 
departing1349512depar_ting
depurating1438642depurating
separation12510432separation
separations1369272separations
separatism1455602separatism
separatist1247192separatist
separative1546972separative
serrating10513212se_rrating
aerating92821003ae__rating
asperating1349563asperating
aspirating1348363aspirating
bepainting15144883bepainting
berating113220763be__rating
deaerating12311563deaerating
decorating14312073decorating
demarcating1745203demarcating
depainting14156153depainting
depilating1439193depilating
deporting1369593depor_ting
depraving1635973dep_raving
derating103222283de__rating
emanating1239003_emanating
epilating12310973_epilating
escalating1347093escalating
federating1548853federating
generating12310393generating
hearting12513123he_ar_ting
imparting1437243impar_ting
operating12313723_operating
parading12313863__parading
parawing14310583__parawing
parting103527383__par_ting
perorating13313133perorating
pirating11314513__pirating
prating103424453__p_rating
recrating121318793re_crating
regrating111316213re_grating
reoperating1449023reoperating
repainting13128973repainting
reparation12612723reparation
reparations13611663reparations
reparative1548173reparative
reparking1638923repar_king
repasting122312843repa_sting
repatriating1545453repatriating
repeating122618983rep_eating
rephrasing1645643rephrasing
replating122217403rep_lating
reporting12513903repor_ting
saturating11119203saturating
scarting113415263s_car_ting
seafaring1345963se_afaring
searching1538343se_arching
searing83330923se_ar__ing
seating84130683se___ating
secreting1279823se_creting
sedating103014113se__dating
sensating1039253se_nsating
separate10310783separat__e
separated1237713separat_ed
separately1553433separately
separates11310743separat_es
separatisms1554653separatisms
separatists1354503separatists
separator1146263separat_or
separators1246503separators
seriating10916403se_riating
smarting113212453s_mar_ting
sparging122611133s_par_ging
sparing104823873s_par__ing
sparking152812543s_par_king
sparkling16226353s_parkling
sparling112714533s_par_ling
sparring113112223s_par_ring
spartina1037983s_par_tina
spatting113111763s_pa_tting
spearing113216103spear__ing
speciating1548123speciating
spectating1546623spectating
spiraling1237953s_piraling
spiriting1238413s_piriting
spirting112913633s_pir_ting
sporting112415463s_por_ting
spraying14299883s_p_raying
spurting113111633s_pur_ting
starting93116173s_tar_ting
supinating1357833supinating
suppurating1644593suppurating
uprating11311113_up_rating
venerating14410053venerating

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.436409841.7
2DLD Change Limit140603917.47018822.4
3Display Results91910.0303033.3
 (SQL Overall)178691917.93622516.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.