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

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

52 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
nondepartmental2071351nondepartmental_
departmental1762764___departmental_
compartmental2162485co__mpartmental_
departmentally2271845___departmentally
nonexperimental2671765nonexperimental_
apartmental1552836____apartmental_
department1546816___department___
departmentalize2971846___departmentalize
departments1645796___department__s
nongovernmental2181696nongovernmental_
noninstrumental17131846noninstrumental_
subdepartment2061276subdepartment___
subdepartments2181166subdepartment__s
compartment1995087co__mpartment___
compartmented2261867co__mpartment_ed
compartmenting2361687co__mpartmenting
compartments2094337co__mpartment__s
condimental1655497cond____imental_
decremental1654677___de_cremental_
deportment1546777___deportment___
deportments1655757___deportment__s
detrimental1454857___de_trimental_
detrimentals1553957___de_trimentals
endearment13106967_ende_ar_ment___
endearments14115387_ende_ar_ment__s
fundamental1752707fund__a__mental_
fundamentals1862497fund__a__mentals
governmental1863487go_ve__rnmental_
grandparental1771577grand_par__ental_
lineamental1353187lin_e_a__mental_
nondependent16154237nondep_endent___
nondependents1793497nondep_endent__s
nondepletable1862347nondep___le_table
nondocumentary2271617nond__ocumentary
nonelementary1862797non_e__lementary
nonexistential2171927non_exist_ential_
nonjudgmental2471497non__judgmental_
nonmental11410857non______mental_
nonoperational1663777nonoperation_al_
nonparametric1962187non__parame_tric
nonparent1148667non__par__ent___
nonparents1246077non__par__ent__s
nonpayment1755077non__pa_yment___
nonpayments1854157non__pa_yment__s
nonsedimentable2071407nonse__dimentable
nonterminal1355317nonte__r_min_al_
nonterminals1453647nonte__r_min_als
nontreatment1454137nontrea_tment___
nontreatments1563297nontrea_tment__s
uniparental1362477_un_ipar__ental_
wonderment1646007wonde__r_ment___
wonderments1754517wonde__r_ment__s

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.343520965.0
2DLD Change Limit95024528.51611158.3
3Display Results52520.0461130.4
 (SQL Overall)178691528.90520066.4
 
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.