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

80 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
deployments195424(None) 
deployment1855521deployment_
employments2054242employments
redeployments2162202redeployments
departments1645793departments
deployers1545063deploy_e_rs
deponents1246673dep_o_nents
deportments1655753deportments
developments2053343developments
employment1955243employment_
enjoyments2254073_enjoyments
redeployment2062673redeployment_
reemployments22122463reemployments
repayments1744903rep_ayments
unemployments22122533unemployments
allotments1244464_allotments
copayments1944314cop_ayments
debarments1545854de_barments
debasements1666174debasements
debatements1656044debatements
decampments2073524decampments
decrements1549384de_crements
defacements1946074defacements
deferments16128584de_ferments
defilements1747074defilements
definements1747114definements
dements103016624de____ments
denotements1446864denotements
denouements1446474denouements
denudements1545334denudements
department1546814department_
dependents1446164dep_endents
deplorers1245464deplo_re_rs
deplores1139534deplo_re__s
deployed1535914deploy_e__d
deployer1445634deploy_e__r
deploying1636154deploy_in_g
deploys1336524deploy____s
deplumes1334944depl_ume__s
deponent11410554dep_o_nent_
deportment1546774deportment_
depravements2054454depravements
derailments1446104derailments
designments1545124designments
despisements1785164despisements
despoilments1753404despoilments
detachments1954594detachments
detainments1485894detainments
determents131010314de_terments
detriments1347364de_triments
development1954214development_
devilments1646384de_vilments
devotements1745614devotements
diplomats1485374diplo_m_ats
diplonts1146474diplo___nts
diplotenes1344654diplo_tenes
dislodgments1783214dislodgments
elements10312174_e_l_ements
eloinments1245994_e_loinments
elopements14146364_e_lopements
embayments1944514_embayments
emoluments1455424_emoluments
endowments1645514_endowments
enjoyment2145034_enjoyment_
enrolments1246854_enrolments
extolments1944404_extolments
implements1647854impl_ements
loments93413474___lo_ments
misemployments22122044misemployments
nonemployments2372504nonemployments
payments1536944__p_ayments
prepayments2053334prep_ayments
reemployment21133044reemployment_
repayment1646344rep_ayment_
repigments1546344rep_igments
replacements1854444replacements
subemployments2571764subemployments
underlayments1972644underlayments
unemployment2193174unemployment_
weldments1544424we_l_dments

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.440406115.9
2DLD Change Limit148819809.34315928.4
3Display Results80800.0461739.1
 (SQL Overall)178691809.82918180.0
 
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.