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

94 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
constant1051559(None) 
constants11410911constants
consent93723112cons_ent
consonant11410162consonant
constancy1646022constancy
constantan1253952constantan
constantly1545182constantly
constraint12411132constraint
consultant1246702consultant
contact1144020682con_tact
content94326152con_tent
contestant1269932contestant
inconstant1256192inconstant
instant7815342_instant
cabstand1344413cabstand
capstan1137903capstan_
capstans1257243capstans
castanet10416193c_astanet
coastal9411043coasta_l
coasting113615513coasting
coastland1243683coastland
cognizant2144123cognizant
colorant10414723colorant
combatant1546053combatant
concent114422513con_cent
confidant1547623confidant
confront13411603confront
conjoint17410373conjoint
conjugant1944893conjugant
conodont11411153conodont
consents102715893cons_ents
consign1038773consign_
consigns1137533consigns
consist9316033cons_ist
consistent1248553consistent
consonants1246483consonants
consort91319903cons_ort
constable13311003constable
constantans1353433constantans
constrain1149333constrain
constrains1249723constrains
constraints1346203constraints
constrict13711623constrict
construct1358713construct
construe1049053construe
consult92513633cons_ult
consultants1354683consultants
contacts123215213con_tacts
contain9315833con_tain
contains10316533con_tains
contend103511893con_tend
contents104018213con_tents
contest93523233con_test
contestants1356803contestants
context163913433con_text
contort91422343con_tort
contract122915633contract
contrast102614783contrast
convent123919413con_vent
coolant9316463co_olant
cornstalk1543943cornstalk
coruscant13246043coruscant
corybant1547573corybant
cosecant12410683cosecant
costa75523733co_sta__
costae85319683co_sta_e
costal85419513co_sta_l
costar85518613co_sta_r
costard104113353co_stard
costars94218013co_stars
costate94019273co_state
costing104323023co_sting
cotan71521783co__tan_
cotans81317923co__tans
cotenant10511793cotenant
couchant1549053couchant
courant9317973co_urant
covenant1349693covenant
croissant1144603croissant
distant83519953_distant
fondant11311143fon_dant
instants8910153_instants
monotint10413713monotint
montane91313623mon_tane
natant6318733__natant
nonconstant1355873nonconstant
nonextant1646203nonextant
nonmutant1145873nonmutant
nutant6316383__nutant
octant81216553_o_ctant
onstage838363_onstage
sonant6621953son__ant
sonorant8411703sonorant
volitant1147863volitant

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162947.04620744.0
3Display Results94940.0462043.5
 (SQL Overall)178691947.26524596.1
 
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.