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

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

46 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
compartmenting236168(None) 
compartment1995083compartment___
compartmental2162483compartment_al
compartmented2261863compartment_ed
compartments2094333compartment__s
complementing2253613comp_lementing
complimenting2252863comp_limenting
coparenting1644613co_par__enting
commenting1749174com____menting
comparting17188374compar____ting
comportment19105464comportment___
comportments2094344comportment__s
comprehending2462734comp_rehending
copartnering1752124co_partne_ring
copresenting1754944co_p_resenting
coarsening1345545co__ar_sen_ing
coattending1543545co__a_ttending
coattesting1443455co__a_ttesting
combatting1755135comba_t___ting
commencing1946185com____mencing
commending1846635com____mending
compacting19177085compa____cting
companioning1952935compa_nion_ing
companying2044815compa____nying
comparing162410585compar_____ing
compassionating2271935compassionating
competing163712465comp____e_ting
complecting2045755comp___lecting
completing1748415comp___le_ting
complotting18124255complot___ting
comporting17199165compor____ting
compressing1846435comp_r__essing
compromising2152925comp_rom_ising
concatenating1853265conca_t_enating
contenting13313325co___nt_enting
experimenting2562375_experimenting
garmenting1445485___gar_menting
impartment1646495_impartment___
impartments1745355_impartment__s
implementing1952705_imp_lementing
margenting1446155__m_ar_genting
ornamenting1452565_orna__menting
parenting12611585___par__enting
patenting1248945___pa_t_enting
smartening1344995_sm_art_en_ing
tormenting1345695to___r_menting

Search took 7 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.1101624463.6
2DLD Change Limit95024466.08015628.9
3Display Results46460.0301533.3
 (SQL Overall)178691466.22028728.5
 
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.