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

88 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
consisting134952(None) 
coassisting1443592coassisting
coexisting2044402coexisting
congesting14410112congesting
consenting13313212consenting
consigning1446782consigning
consistent1248552consistent
consorting13410742consorting
consulting1349082consulting
contesting13312212contesting
convicting1847582convicting
insisting1038822_insisting
assisting1046183_assisting
censusing1244813census_ing
coasting113615513co__asting
coediting1338333coedi_ting
cognising1347043cognis_ing
cohosting1546323co_hosting
colistin10410553co_listin_
colistins1149223co_listins
combusting1745453combusting
committing1746683committing
composting17178053composting
conceiting15311773conceiting
concerting15313893concerting
concocting1448413concocting
concreting1539873concreting
concussing1546143concussing
conducting1648833conducting
confecting18310553confecting
confessing1647183confessing
confiding1638333confi_ding
confining1539993confi_ning
confirming1845903confirming
confiscating2053613confiscating
conflating16410003conflating
conflicting1944723conflicting
confusing1537333confus_ing
confuting1539093con_futing
connecting15310383connecting
conniving1537093conni_ving
connoting12310023con_noting
conscripting1954023conscripting
conserving1639763conserving
considering1544843considering
consist9316033consist___
consisted1238503consist_ed
consistence1555673consistence
consistency1853973consistency
consistory1545573consistory
consists10310593consist__s
consociating1755573consociating
consoling12310873cons_oling
conspiring1546553conspiring
constipating1775393constipating
constituting1554653constituting
constricting1747023constricting
construing1347443construing
consuming1437913cons_uming
contacting15610073contacting
contenting13313323contenting
continuing1348193continuing
contorting13410103contorting
contrasting1459353contrasting
contusing1239143contus_ing
convecting18310433convecting
conventing16311543conventing
converting16313133converting
convincing1845343convincing
corseting12312173cors_eting
cosigning1345393co_signing
cosseting1239543co_sseting
costing104323023co___sting
cowriting1557323cowri_ting
desisting112810383_desisting
enlisting1038343_enlisting
foisting122910503fo__isting
hoisting123610903ho__isting
ionising9310223ion_is_ing
joisting16328503jo__isting
monishing1547543mon_ishing
nonbiting1247823nonbi_ting
nonrioting1146753nonrioting
nonsuiting1147273nonsuiting
persisting1346653persisting
positing11312303po_si_ting
resisting103215313_resisting
subsisting1345533subsisting

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.406440125.6
2DLD Change Limit140603886.23622547.0
3Display Results88880.0302933.3
 (SQL Overall)178691886.67226782.2
 
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.