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 “cognizer” 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
cognizer205586(None) 
cognize1957681cognize_
cognized2136291cognized
cognizers2164431cognizers
cognizes2058031cognizes
cognise1059682cognise_
cognised1256312cognised
cognises11610042cognises
colonizer20309282colonizer
conifer123212642co_nifer
conniver1337492conniver
cornier93017092corni_er
ionizer162310122io_nizer
recognizer2254452recognizer
agnize16329563_agnize_
agnized18247223_agnized
agnizes17328843_agnizes
agonize172911403agonize_
agonized19258993agonized
agonizes182610583agonizes
boggier113711583boggi_er
bonier84321993bo_ni_er
bonnier94711313bonni_er
bonzer175313673bo_n_zer
botanizer2046243botanizer
cagier93715933cag_i_er
cannier94014163canni_er
canonizer2046693canonizer
cloggier1244253cloggi_er
coalier93416183coali_er
cobbier133410163cobbi_er
cockier154013623cocki_er
codriver1435913codriver
cognate10312203cognate_
cognates11311583cognates
cognizant2144123cognizant
cognizing2247173cognizing
cognomen1346083cognomen
coiler84421593co__iler
coiner84323783co__iner
coinfer12419393coin_fer
cointer93616723coin_ter
collider113410423collider
collier93618153colli_er
colonize192312773colonize_
colonized212710433colonized
colonizers21286723colonizers
colonizes202613183colonizes
colorizer202410623colorizer
combiner14259723combiner
comfier1439163comfi_er
compiler1438373compiler
conciser12310243conciser
confer114018683co_n_fer
confider1438123confider
confiner13311193confiner
congener112412203congener
conger95024273co_n_ger
conies84338593co_ni_es
conifers133611703co_nifers
conine84528553co_nine_
conines93827793co_nines
conker124721553co_n_ker
conner84423963co_n_ner
connive1238993connive_
connived1436433connived
connivers1436933connivers
connivery1744213connivery
connives1339723connives
conquer1838623co_nquer
consider11310393consider
copier103722893co_pi_er
corkier133114303corki_er
corner84625623corn__er
cornice11612933cornice_
corniced1368593corniced
cornices12713293cornices
cosier84423753co_si_er
cottier93814173cotti_er
counter94220153coun_ter
courier93617893couri_er
cowier113616163co_wi_er
cowinner1334753cowinner
cowriter13238883cowriter
cozier173315143co_zi_er
doggier103810943doggi_er
dognaper1243693dognaper
donniker1333923donniker
downier11299703downi_er
foggier12349913foggi_er
goonier83612843gooni_er
hornier103012463horni_er
igniter8147673_igniter
iodizer17408663io_dizer
ionize154613873io_nize_
ionized172611293io_nized
ionizers17257713io_nizers
ionizes162813343io_nizes
lionizer1756053lionizer
loggier93811143loggi_er
logier75015733log_i_er
loonier73312683looni_er
moniker1338673mo_niker
moonier93714103mooni_er
organizer1946753organizer
ozonizer1654473ozonizer
paganizer2145763paganizer
poetizer1936813poetizer
pornier93413133porni_er
recognize2145673recognize_
recognized2345253recognized
recognizers2353213recognizers
recognizes2255573recognizes
soggier93410883soggi_er
tonier65520713to_ni_er
womanizer2346243womanizer

Search took 9 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.750238254.7
2DLD Change Limit1461621167.51619446.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.31221498.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.