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

91 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
condition1241116(None) 
conditions13410101conditions
coalition1148702coalition
cognition1247012cognition
coition9314312co__ition
conation101420882con_ation
concision1348492concision
conditional1447112conditional
conditioned1564282conditioned
conditioner1474662conditioner
conduction1549962conduction
connation11314262connation
conniption1446272conniption
contrition12411422contrition
conviction1748182conviction
decondition1545412decondition
monition10311722mon_ition
recondition1447122recondition
rendition1058932rendition
vendition1345692vendition
addition1096893_addition
audition979173_audition
caudation1269993caudation
coaction12310773co_action
coalitions1247923coalitions
coediting1338333coediting
coeditor1145723coedit_or
cognation12310753cognation
cognitions1346043cognitions
coitions10312853co__itions
collation11313993collation
collision1146943collision
commotion1576983commotion
conations111318903con_ations
conception16410453conception
concisions1448243concisions
concoction1348233concoction
concretion1449293concretion
condign1147733cond__ign
conditionals1554973conditionals
conditioners1563923conditioners
conditioning1653683conditioning
condonation1448853condonation
conductions1649663conductions
confection17411183confection
confiteor1443873confiteor
conflation15412083conflation
confliction1845233confliction
confusion1446473confusion
congestion1349043congestion
conidian1168383con_idian
connations12312943connations
connection14410533connection
connexion1874603connexion
conniptions1546033conniptions
contagion1246993contagion
contention12412223contention
contortion1248663contortion
contritions13410913contritions
contusion1147063contusion
convection17411123convection
convention15410563convention
convictions1848053convictions
cooption1288343co_option
deconditions1645283deconditions
dentition1049633dentition
donation91513783don_ation
edition8310853__edition
erudition1046173erudition
foundation1443803foundation
ignition946533ign_ition
indiction1239813_indiction
iodation9310383io_dation
lenition8310083len_ition
monitions11310883mon_itions
munition1038763mun_ition
nonaction1149443nonaction
nonfiction1546303nonfiction
perdition1249013perdition
position10912193po_sition
precondition1755243precondition
punition1038373pun_ition
reconditions1546823reconditions
reedition1047833reedition
renditions1149183renditions
sedition939333_sedition
sortition946703sortition
tradition1047593tradition
venditions1445523venditions
volition1179173vo_lition
zonation171410723zon_ation

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 Filter1786911486410.420425454.8
2DLD Change Limit148641916.64322375.6
3Display Results91910.0461978.3
 (SQL Overall)178691917.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.