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

43 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
coexisting204440(None) 
coediting1338332coedi_ting
coexerting2045492coexerting
coexistent1984242coexistent
consisting1349522consisting
existing1639072__existing
bemisting1438073_bemisting
cherishing1944833cherishing
coassisting1443593coassisting
coasting113615513co__asting
coempting1636073coe_mpting
coenacting1545873coenacting
coequating2245323coequating
coerecting15218783coerecting
coexist1638583coexist___
coexisted1944153coexist_ed
coexistence2253263coexistence
coexists1735653coexist__s
cognising1347043cognis_ing
cohosting1546323co_hosting
colistin10410553co_listin_
colistins1149233co_listins
combusting1745453combusting
committing1746683committing
composting17178053composting
congesting14410113congesting
contesting13312213contesting
convicting1847583convicting
costing104323023co___sting
cowriting1557323cowri_ting
crediting1338843credi_ting
cresting114017043cre__sting
delisting112710503_delisting
desisting112810383_desisting
exiting15311393__exi_ting
foisting122910503fo__isting
heisting123411043_he_isting
hoisting123610903ho__isting
joisting16328503jo__isting
poetising1238713poetis_ing
preexisting2144223preexisting
relisting102414353_relisting
resisting103215313_resisting

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.656272394.8
2DLD Change Limit140603435.81324187.7
3Display Results43430.0301433.3
 (SQL Overall)178691436.49927495.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.