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

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
compassionating227193(None) 
compassionate1963093compassionat__e
compassionated2162393compassionat_ed
compassionately2471863compassionately
compassionates2062603compassionat_es
commissioning2092624commission__ing
companioning1952934compa_nion__ing
impassioning1752784_impassion__ing
assassinating1461455_assassi_nating
coassisting1443595co__assi__sting
commissionaire2072095commissiona_ire
companionate1863075compa_nionat__e
compartmenting2361685compartmen_ting
compassing1746545compass_____ing
compassion1645985compassio____n_
compassionless2092105compassion_less
compassions1745765compassio____ns
compensating1955005compens___ating
complicating2145635comp__li_cating
compositing1846265comp_osi___ting
contaminating1854915conta_mi_nating
impersonating1873205_impers_onating
passivating1743785___passi_vating
uncompassionate2181635uncompassionat__e
bombinating1844426bom___bi_nating
cachinnating2092106c___achinnating
campaigning1952006campa__ign__ing
camphorating2252566camp___horating
capacitating1952556c_apa_ci_tating
caparisoning1772066c_aparison__ing
carbonating1645856c___a_rbonating
castigating1546006c___asti_gating
collaborating1852586colla__borating
comanaging1644326com_a____naging
commemorating1953076com__memorating
comminuting1844506com___mi_nuting
commiserating2053196com_mis_erating
commissionaires2181776commissionaires
communicating2254876com_muni_cating
compacting19177086compa_____cting
companionable2162536compa_niona_ble
companionably2462546compa_niona_bly
companionship2462116compa_nionshi_p
companionships2571806compa_nionships
companying2044816compa____n_ying
comparting17188376compa_____rting
compatriotic2062176compatrio__ti_c
complaining1844726comp_lai_n__ing
complementing2253616comp_lemen_ting
complimenting2252866comp__limenting
complotting18124256comp___lo_tting
comporting17199166comp____o_rting
composting17178046comp____o_sting
compressional1954256compressiona___l
concatenating1853266conca__tenating
concessionaire18142436concessiona_ire
confessionalism2272436confessionalism
confessionalist2072526confessionalist
conglutinating1862426congluti_nating
consternating1654976co__nsternating
constipating1775396co__nsti_pating
coordinating1653916co__ordi_nating
coparenting1644616co_pa__ren_ting
copresenting1754946co_pres_en_ting
coronating13410176co_____ronating
cotransporting1991796cotranspo_rting
decommissioning2371486decommission__ing
dispassionate1662176dispassionat__e
dispassionately2171216dispassionately
domesticating1953026dom_esti_cating
dominating1449406dom____i_nating
fascinating1745246___fasci_nating
fractionating1953086__fractionating
impainting1544506_impa__i_n_ting
machinating1945616__m_achi_nating
marginating1545896__m_argi_nating
marinating13410266__m_a_ri_nating
masticating1647836__m_asti_cating
missioning1347406__m_ission__ing
missionizing2453196__m_issionizing
nominating1349506nom____i_nating
occasioning1652516_occa_sion__ing
paginating1447526___pa_gi_nating
passionate1245976___passionat__e
passionately1752056___passionately
patinating1339876___pa_ti_nating
pepsinating1645376___pepsi_nating
personating1447676___pers_onating
procrastinating2072196procrasti_nating
proportionating2072346proportionating
recommissioning2271666recommission__ing

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 Filter178691950240.1231452772.4
2DLD Change Limit95024918.22011560.1
3Display Results91910.0801137.5
 (SQL Overall)178691918.42321214.7
 
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.