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

100 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
consorting1341074(None) 
contorting13410101contorting
censoring1238782censor_ing
comforting18165932comforting
comporting17199162comporting
concerting15313892concerting
concocting1448412concocting
conforming1847372conforming
connoting12310022conno_ting
consenting13313222consenting
conserving1639762conserving
consisting1349522consisting
consoling12310872conso_ling
consortia1146252consorti_a
consortium1454532consortium
construing1347442construing
consulting1349082consulting
converting16313132converting
nonsporting1444822nonsporting
assorting1037303_assorting
cavorting1536063c_avorting
censuring1237603censur_ing
coasting113615513coas__ting
coexerting2045493coexerting
cohosting1546323co_hosting
coinsuring1345373coinsur_ing
coloring11414843co_lor_ing
comparting17188383comparting
composting17178053composting
conceiting15311773conceiting
concerning1548903concerning
concertina14410633concertina
concertino14910843concertino
concreting1539873concreting
concurring1546603concurring
condoling13510373condo_ling
condoning1339783condo_ning
conducting1648833conducting
confecting18310553confecting
conferring1648743conferring
confirming1845903confirming
conflating16410003conflating
confronting1744863confronting
confuting1539093con_futing
congesting14410113congesting
conjoining2046103conjoining
conjuring1937913conjur_ing
connecting15310383connecting
conscribing1853903conscribing
conscripting1954023conscripting
consecrating1747943consecrating
consigning1446783consigning
consociating1755573consociating
consort91319903consort___
consorted1239773consort_ed
consortiums1562853consortiums
consorts101512343consort__s
conspiring1546553conspiring
constrain1149333constrain_
constrains1249733constrains
constraint12411133constraint
constricting1747023constricting
constringe1345853constr_inge
constructing1746753constructing
consuming1437913cons_uming
contacting15610073contacting
contenting13313323contenting
contesting13312213contesting
contortion1248663contortion
contortions1348693contortions
contortive1546843contortive
contouring1347013contouring
convecting18310433convecting
conventing16311543conventing
converging1758093converging
conversing16310543conversing
convicting1847583convicting
convoking1935743convo_king
convoluting1744203convoluting
convolving1944413convolving
convoying1835983convo_ying
coopting133411313co__opting
coplotting1555953coplotting
corseting12312173cors_eting
cosseting1239543co_sseting
costing104323023co_s__ting
courting112514573co__urting
honoring12310473hon_or_ing
inserting10914243_inserting
intorting10311413_intorting
missorting1347123missorting
nonsuiting1147273nonsuiting
nonvoting1346903nonvo_ting
nonworking1844213nonworking
presorting1339983presorting
resorting10614613_resorting
snorting92613373_sn_orting
sorting83221813___sorting
sponsoring1343633sponsor_ing
tonsuring1046503tonsur_ing

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 Filter1786911406030.420425454.8
2DLD Change Limit1406031006.39022003.6
3Display Results1001000.0502000.0
 (SQL Overall)1786911006.86026048.3
 
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.