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

46 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
concluder144417(None) 
conclude1344661conclude_
concluded1544021concluded
concluders1543491concluders
concludes1445131concludes
colluder11276862co_lluder
conceder1338732conc_eder
coholder1436063cohol_der
colder95121833co__l_der
collider113410413co_llider
collude10337983co_llude_
colluded12296453co_lluded
colluders12285613co_lluders
colludes11279213co_lludes
concealer1368213concealer
concede12310093conc_ede_
conceded1438283conc_eded
conceders1437953conc_eders
concedes13311053conc_edes
conceiver1657413conceiver
concenter13312213concenter
conciser12310243conc_iser
conclave1556403conclave_
conclaves1646543conclaves
concluding1644913concluding
conclusory1752263conclusory
concocter1247623concocter
concur10411093conc_u__r
conducer13127363con_ducer
confider1438123con_fider
confluxes2143833confluxes
confounder1643493confounder
confuter1338503con_futer
conjurer17117673con_jurer
conquer1838613con_qu_er
consider11310393con_sider
consulter1198223consulter
consumer1238503con_sumer
contender1239563contender
excluder1843453_excluder
include1036083_include_
included1234833_included
includes1146023_includes
occlude1263183_occlude_
occluded1492593_occluded
occludes1363103_occludes

Search took 9 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 Filter1786911486410.1531167915.0
2DLD Change Limit148641467.81319024.8
3Display Results46460.0162875.0
 (SQL Overall)178691467.98222386.7
 
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.