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

116 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
contrive1331134(None) 
contrite10318521contrite
contrived1547991contrived
contriver1448331contriver
contrives14311701contrives
coderive1447682coderive
codrive1337642co_drive
conative131214622conative
conceive1539232conceive
connive1238992con_nive
contortive1546842contortive
contrivers1547242contrivers
contusive1445782contusive
costive12312842cost_ive
cantrip112910033cantri_p
cantrips12318923cantrips
captive1438973capt_ive
centile94217183cent_ile
centime114513033cent_ime
centre84316643centr__e
centric11312393centri_c
centring112112953centring
centriole1145673centriole
centrism1249643centrism
centrist10314863centrist
chondrite1545223chondrite
citrine92514023c_itrine
coactive1598613coactive
coderived1644793coderived
coderives1547483coderives
codriven1444393co_driven
codriver1435903co_driver
codrives1437663co_drives
codrove1336423co_drove
coercive1545873coercive
cognitive1545483cognitive
cohesive1646073cohesive
colorize192314203colorize
comprise14310813comprise
comprize2368733comprize
concave1439373con_cave
conceived1746713conceived
conceiver1657413conceiver
conceives1639233conceives
conchie143312683conchi_e
concise11314473con_cise
conclave1556403conclave
concrete12411083concrete
conducive1745263conducive
confide13310203con_fide
confine12315583con_fine
confrere1347563confrere
coniine9316803con_iine
conine84528553con__ine
connived1436433con_nived
conniver1337493con_niver
connives1339723con_nives
conscribe1545923conscribe
conserve1339923conserve
conspire1257873conspire
constative15410103constative
constrict13711593constrict
constringe1345833constringe
construe1049043constr_ue
contain9315823contai_n
contained12310893contained
container11311073container
contains10316533contains
conte76633203cont___e
continue10311123continue
contra83314693contr__a
contract122915623contract
contractive1849513contractive
contrail10410963contrail
contrails11410543contrails
contrary1347493contrary
contras93015603contr_as
contrast102614783contrast
contrastive1647293contrastive
contravene1545093contravene
contribute1455473contribute
contritely1545783contritely
contrivance1854253contrivance
contriving1648193contriving
control9310673contr_ol
controls10311393controls
controvert1547173controvert
contuse9311413cont_use
convolve1644653convolve
coontie9311413coont_i_e
cootie84223073coot_i_e
corrie83621213co_rri_e
coterie9417393coteri_e
countries11313593countries
couthie121810543couthi_e
cowrie113814273co_wri_e
cowrite123612683co_write
doctrine1146733doctrine
donative12139873donative
gentrice1148813gentrice
monitive1349993monitive
motive113112143mo_t_ive
noncrime12116603noncrime
nondriver1344853nondriver
outdrive1236883_outdrive
outgive11199253_outgive
outlive102513033_outlive
outrave102614413_outrave
outride82615673_outride
pontine92419053pont_ine
postdive1445763postdive
restrive11310923restrive
strive95020963__strive
tontine72316143tont_ine
uncontrived1753613uncontrived
votive12348933vo_t_ive

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.1561145455.1
2DLD Change Limit1461621167.06320694.0
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.26524596.1
 
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.