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

126 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
carnifies143990(None) 
carnified1547291carnified
cornifies1439001cornifies
calcifies1638922calcifies
canities101519262ca_nities
carnies94123962carn__ies
carnitines1277812carnitines
certifies14310322certifies
clarifies1448632clar_ifies
cornified1546622cornified
damnifies1545542damnifies
magnifies1547282magnifies
rarifies11311942rar_ifies
scarifies1439602scar_ifies
acetifies1447133acetifies
acidifies15126453acidifies
aerifies111313393_aerifies
argufies1243743_argufies
artifices1446483_artifices
basifies13310493ba_sifies
calcified1746893calcified
calvities1438943calvities
canaries10318943ca_naries
candies104125613ca_n_dies
canikins14219163ca_nikins
canines93724033ca_ni_nes
caninities12410493caninities
canneries11313083canneries
cannikins15225683cannikins
canopies12311853ca_nopies
caprifigs1742703caprifigs
carafes125015713car_af_es
carbides133111693carbi_des
carbines123617553carbi_nes
cardioids1345243cardioids
carditis11310233carditi_s
carditises1346973carditises
caribes113715643car_i_bes
carices114220953car_i_ces
caries85147623car___ies
carioles10817083car_ioles
carlines103521673carli_nes
carmines123617883carmi_nes
carnages11312213carn_ages
carnalities1348783carnalities
carnie84421093carn__ie_
carnify1555883carnif__y
carnifying1945043carnifying
carnitine1178573carnitine
carnivals1444503carnivals
carnivores1553363carnivores
carnivories1653413carnivories
carnotites1246553carnotites
carriages1238333carriages
carries94328013car__ries
carrioles1169483carrioles
casefies1339213ca_sefies
cavities131412613ca_vities
certified1548423certified
certifier1447353certifier
certifiers1545153certifiers
charities14312743char_ities
citifies13310683c_itifies
clarified1546973clar_ified
clarifier1446123clar_ifier
clarifiers1544013clar_ifiers
clarities11312483clar_ities
classifies1555003classifies
coalifies1439113coalifies
codifies1439643c_odifies
cornices12713303corni_ces
corniches1666683corniches
cornicles1368253cornicles
craniates11310653craniates
crannies10313013cran_nies
crucifies1646123crucifies
damnified1644883damnified
dandifies1476893dandifies
dignifies1446363dignifies
falsifies1545983falsifies
fancifies1767083fancifies
fortifies1548693fortifies
garnishes13198813garnishes
gasifies1238693ga_sifies
gratifies1347993gratifies
horrifies15146393horrifies
ignifies1277563_ignifies
lignifies1346263lignifies
magnified1645763magnified
magnifier1545273magnifier
magnifiers1643813magnifiers
minifies13312903_minifies
mortifies1439393mortifies
nazifies2036063na_zifies
pacifies15311233pa_cifies
parities10522983par_ities
purifies13311933pur_ifies
ramifies13310503ra_mifies
rarefies1138993rar_efies
rarified1239053rar_ified
rarities8316333rar_ities
ratifies11313513ra_tifies
reifies104218283__reifies
reunifies1247583reunifies
salifies11314793sa_lifies
salsifies1247253salsifies
sanities81219773sa_nities
saponifies1544713saponifies
scarcities1446403scarcities
scarified1547293scar_ified
scarifier1446653scar_ifier
scarifiers1544103scar_ifiers
scorifies1448023scor_ifies
signifies1347063signifies
tackifies1845783tackifies
tarnishes12188893tarnishes
terrifies12139723terrifies
torrifies12137033torrifies
unifies102714713__unifies
vanities111414493va_nities
varnishes15207923varnishes
varsities1239243varsities
verbifies17157133verbifies
verifies141313483ver_ifies
versifies15159333versifies
vinifies1439873_vinifies

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 Limit1486411267.34320242.5
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.82622833.0
 
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.