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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
conceiting1531177(None) 
conceiving1846771conceiving
concerting15313891concerting
concealing1549302concealing
conceding1559342conce_ding
concerning1548902concerning
concertina14410612concertina
concertino14910842concertino
concocting1448412concocting
concreting1539872concreting
confecting18310552confecting
congesting14410112congesting
connecting15310382connecting
consenting13313222consenting
contenting13313322contenting
contesting13312212contesting
convecting18310432convecting
conventing16311542conventing
converting16313132converting
bonneting1236173bonne_ting
canceling14310163cance_ling
cancelling1547213cancelling
circuiting1545363circuiting
coacting133412703coac__ting
cocreating15310293cocreating
coediting1338333co_editing
coerecting15218783coerecting
coexerting2045493coexerting
cohabiting1844803cohabiting
coinciding1644623coinc_iding
coinfecting1944573coinfecting
coinventing1744543coinventing
collecting1548283collecting
colleting12311053colle_ting
commenting1749173commenting
competing163712463compe_ting
concaving1737353conc_aving
conceit113218073conceit___
conceited14310423conceit_ed
conceits122813613conceit__s
concentering1755433concentering
concepti14328273concepti__
conception16410453conception
conceptions17410593conceptions
conceptive1949513conceptive
concertgoing1852623concertgoing
concerti122912603concerti__
concertinas15107553concertinas
concertinos15158123concertinos
concertize23169353concertize
concertizing2655633concertizing
conciliating1775613conciliating
concluding1644913concluding
concretizing2654303concretizing
concurring1546603concurring
concussing1546143concussing
condemning1665743condemning
condensing1447743condensing
conducting1648833conducting
conferring1648743conferring
confessing1647183confessing
confiding1638333con_fiding
confining1539993con_fining
conflating16410003conflating
conflicting1944723conflicting
confuting1539093con_futing
congealing1447633congealing
congeeing1337903conge_eing
conjoining2046103conjoining
conniving1537093con_niving
connoting12310023con_noting
conscribing1853903conscribing
conscripting1954023conscripting
conserving1639763conserving
consisting1349523consisting
consorting13410743consorting
conspiring1546553conspiring
consulting1349083consulting
contacting15610073contacting
containing13410933containing
contemning1577063contemning
contending1449123contending
contorting13410103contorting
contriving1648193contriving
convening15311193conve_ning
converging1758093converging
conversing16310543conversing
conveying1838323conve_ying
convicting1847583convicting
copyediting2052243copyediting
coquetting2244513coquetting
correcting15199303correcting
corseting12312173corse_ting
coscripting1843903coscripting
cosseting1239543cosse_ting
coveting141912303co_ve_ting
cowriting1557323co_writing
forfeiting1744133forfeiting
incenting12912063_incenting
incepting1489293_incepting
inciting11312533_inc_iting
nonbetting1345843nonbetting
nonbiting1247823non_biting
nonmeeting1346073nonmeeting
nonsuiting1147273nonsuiting
reconceiving2093453reconceiving
sonneting1037003sonne_ting
sonnetting1144823sonnetting

Search took 8 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.466383457.1
2DLD Change Limit1406031086.81320637.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.32524394.7
 
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.