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

81 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
complementation2392691complementation_
implementation2063153_implementation_
implementations2162883_implementations
complementaries2372344complementari_es
complementarily2682384complementari_ly
complementarity2682234complementari_ty
complementing2253614complemen__ti_ng
supplementation2171894supplementation_
cementation1559705c____ementation_
cementations1659015c____ementations
commendation1946505com___mendation_
commendations2055795com___mendations
commentating1957035com___mentati_ng
compensation18126505comp___ensation_
compensational2073525comp___ensational
compensations19136175comp___ensations
complemental2054355complementa____l
complementary24123595complementa___ry
complementizer3172225complemen__tizer
complexation25144245compl__e_xation_
complexations26134005compl__e_xations
complimentarily2692155complimentari_ly
complimenting2252865complimen__ti_ng
alimentation14105336___alimentation_
alimentations1594996___alimentations
columniation1665416co__lum_niation_
columniations1764786co__lum_niations
commemoration1853886com_mem_oration_
commemorations1953436com_mem_orations
commentator1755276com___mentat_o_r
commentators1854796com___mentat_ors
commination171111636com___min_ation_
comminations18810476com___min_ations
commutation1747996com___m_utation_
commutations1847256com___m_utations
compellation1855106comp___ellation_
compellations1954796comp___ellations
compensating1954996comp___ensati_ng
competition1755776comp___e_tition_
competitions1845526comp___e_titions
complement18510106complemen__t____
complemented2154176complemen__t__ed
complementizers3291626complement_izers
complements1948186complemen__t___s
completion1647306compl__e___tion_
completions1746906compl__e___tions
complication2048196compl___ication_
complications2147426compl___ications
complimentary24133156complimenta___ry
comprehension2262976comprehen__sion_
comprehensions2362656comprehen__sions
computation1748716comp____utation_
computational1994576comp____utational
computations1848116comp____utations
condemnation1746046co_ndem_n_ation_
condemnations1845406co_ndem_n_ations
conglomeration1962996conglome_ration_
conglomerations2062726conglome_rations
depigmentation20103046_depigmentation_
depigmentations21102846_depigmentations
documentation18144726do__cumentation_
documentational2061966do__cumentational
documentations19144486do__cumentations
fomentation1647716fo____mentation_
fomentations1746796fo____mentations
implantation1653356_impl__antation_
implantations1753246_impl__antations
implementing1952706_implemen__ti_ng
lamentation13106576____lamentation_
lamentations1495986____lamentations
ornamentation1573616_o_rnamentation_
ornamentations1673256_o_rnamentations
pigmentation1754486___pigmentation_
pigmentations1854096___pigmentations
placentation1694156___placentation_
placentations17103636___placentations
presentation1448996___presentation_
presentational1673216___presentational
presentations1548136___presentations
representation16154126_representation_
representations17153896_representations

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 Filter178691658740.0931921408.6
2DLD Change Limit65874816.6569896.9
3Display Results81810.0631285.7
 (SQL Overall)178691816.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.