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 “conceive” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
conceive153923(None) 
conceived1746711conceived
conceiver1657411conceiver
conceives1639231conceives
coactive1598622coactive
conative131214622conative
concave1439372conc_ave
concede12310102conce_de
conceit113218072concei_t
conceited14310422conceited
conceits122813612conceits
conceivers1746312conceivers
conceptive1949512conceptive
concessive1745822concessive
conchie143312682conchi_e
concise11314472conc_ise
conclave1556402conclave
connive1238992con_nive
conserve1339932conserve
contrive13311352contrive
reconceive1745292reconceive
cocaine111315173co_caine
codeine103815033co_deine
coderive1447693coderive
codrive1337653co_drive
coercive1545873coercive
cognitive1545483cognitive
cohesive1646073cohesive
coincide1346493coinc_ide
concaved1636223conc_aved
concaves1538913conc_aves
conceal113313013conce_al
concealed1458133concealed
concealer1368223concealer
conceals123111023conceals
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceding1559343conceding
conceivable2054993conceivable
conceiving1846773conceiving
concent114422513conce_nt
concenter13312213concenter
concents122516603concents
concept133314443conce_pt
concepti14328273concepti
concepts143110303concepts
concern113011963conce_rn
concerned1438643concerned
concerns122710833concerns
concert113325223conce_rt
concerted14312113concerted
concerti122912603concerti
concertize23169353concertize
concerto123311613concerto
concerts123016063concerts
conchae143911643conc_hae
conchies153214853conchies
concierge1444253concierge
conciser12310243conc_iser
conclaves1646543conclaves
conclude1344673conclude
conclusive1744203conclusive
concoctive1646803concoctive
concrete12411083concrete
concretize23166713concretize
concubine1545753concubine
concussive1744213concussive
condense1179613condense
conducive1745283conducive
conductive1848143conductive
conferee13613733conferee
conferva1644433conferva
confervae1745143confervae
confide13310203con_fide
confine12315583con_fine
congee96024473conge__e
congestive1647613congestive
coniine9316803con_iine
conine84528553con__ine
connective1749253connective
connived1436433con_nived
conniver1337493con_niver
connives1339723con_nives
conscribe1545923conscribe
conserved1538853conserved
conserver1448723conserver
conserves14311193conserves
conspire1257873conspire
contrite10318543contrite
contrived1547993contrived
contriver1448343contriver
contrives14311703contrives
contusive1445783contusive
convective2049113convective
convene123314323conve_ne
converge1437393converge
converse13310263converse
convolve1644653convolve
costive12312843co_stive
croceine1248033croceine
deceive1337813_deceive
donative12139873donative
misconceive2063163misconceive
monitive1349993monitive
nonactive1448973nonactive
noncrime12116603noncrime
perceive1546973perceive
preconceive2053353preconceive
receive1239733_receive
reconceived1953783reconceived
reconceives1864263reconceives

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.406440125.6
2DLD Change Limit1461621127.20320291.8
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.65523343.0
 
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.