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

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

85 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
comparting1718837(None) 
compacting19177071compacting
comparing162410581compar_ing
comporting17199161comporting
combating16310142comba_ting
combatting1755132combatting
comforting18165932comforting
companying2044812companying
compassing1746542compassing
compering163414162comper_ing
competing163712462comp_eting
completing1748412completing
composting17178042composting
compting153013602comp__ting
computing16309842comp_uting
imparting1437242_imparting
ramparting1543882ramparting
bogarting1334653bo_garting
bombarding1843833bombarding
carting104228283c___arting
charting142614193c__harting
coacting133412703co__acting
coapting133511613co__apting
coasting113615513co__asting
coating103525313co__a_ting
coempting1636073coemp__ting
coenacting1545863coenacting
coexerting2045493coexerting
collaring12310543collar_ing
collating12312753colla_ting
comaking1739993com_a_king
combusting1745423combusting
commanding1845913commanding
commenting1749163commenting
commercing1955963commercing
committing1746673committing
commuting16288433com_muting
compaction1846753compaction
compactions1946533compactions
comparatist1756323comparatist
comparative20176213comparative
compart134016003compart___
comparted16338423compart_ed
compartment1995083compartment
comparts144210833compart__s
compatriot1655963compatriot
compeering1747053compeering
compelling1746553compelling
compiling1637763comp_iling
comping143518593comp___ing
complaining1844723complaining
complecting2045743complecting
complexing2444743complexing
complotting18124253complotting
complying1936113comp_lying
composing16179843comp_osing
compositing1846253compositing
comprising1748633comprising
comprizing2647463comprizing
concerting15313893concerting
consorting13410743consorting
contacting15610063contacting
contorting13410103contorting
converting16313133converting
cooperating1648413cooperating
coopering142611323cooper_ing
coopting133411313coop__ting
coparenting1644613co_parenting
coppering162810893copper_ing
costarring1345393costarring
courting112514573co__urting
covarying1844133co_varying
departing1349513_departing
disparting1438933disparting
homeporting1953043homeporting
impacting1635943_impacting
imparking1834713_imparking
impasting1436313_impasting
importing1438193_importing
marting103325013__m_arting
misparting1538083misparting
oompahing1773173oompa_hing
parting103527383___parting
smarting113212453_sm_arting
tomcatting1542423tomcatting

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 Filter1786911406030.1531167915.0
2DLD Change Limit140603858.91015780.4
3Display Results85850.0761118.4
 (SQL Overall)178691859.13919552.6
 
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.