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

137 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
cologned123715(None) 
cologne1039351cologne_
colognes11310601colognes
clogged12528652c_logged
cloned94518802c_lo_ned
clowned13447722c_lowned
cocooned1337292cocooned
coigned11418662co_igned
cojoined1856292cojoined
collogued1344072collogued
colone85425002colo_ne_
colonel94213282colo_nel
colones96124432colo_nes
colored10313472colo_red
coloured1148302coloured
columned1334922columned
cosigned1235722cosigned
aligned9128553_aligned
belonged1235313belonged
bologna1044253bologn_a
bolognas1144073bolognas
boloney1247763bolo_ney
boogied11379283bo_ogied
calcined1338743calcined
clagged12749233c_lagged
clanged114212653c_langed
cleaned103512003c_leaned
clinged113310093c_linged
cloaked14368543c_loaked
clocked164112833c_locked
clogger11438803c_logger
clomped14398973c_lomped
clone75728163c_lo_ne_
cloner84418093c_lo_ner
clones84526563c_lo_nes
clonked14429563c_lonked
clopped143611523c_lopped
closed95317963c_lo_sed
clothed134010283c_lothed
clotted104011823c_lotted
clouded11348833c_louded
cloured103111543c_loured
clouted104212163c_louted
cloyed125111563c_lo_yed
coffined1735993coffined
cofound1335513cofoun_d
cofounded1643463cofounded
cogged116416613c__ogged
cohosted1436133cohosted
coigne94612193co_igne_
coignes103912153co_ignes
coined94523603c__oined
cojones163512103cojo_nes
coled85540753col___ed
coleseed1147393coleseed
collaged12279963collaged
collared113211143collared
collated113615063collated
colleted113011653colleted
collided12309793collided
collied103316673col_lied
collogue1145463collogue_
collogues1246213collogues
colluded12296453colluded
colocated1439613colocated
colog86619933colog___
cologs96517353colog__s
colon78630193colo_n__
colonels104210453colo_nels
coloni85619203colo_n_i
colonic115015713colo_nic
colonies103620013colonies
colonised12248723colonised
colonized212710433colonized
colonnade1243083colonnade
colonnaded1441943colonnaded
colons86028683colo_n_s
colonus94413443colo_nus
colony115417273colo_n_y
colorbred1443953colorbred
coloreds1138093colo_reds
colorer9312523colo_rer
colorized212211773colorized
colormen1247243colormen
colourer1037553colourer
columnea1243673columnea
combined15269183combined
communed15338203communed
condoned122612023condoned
coned86040053c__o_ned
confined14310403confined
congaed11399743co_ngaed
congeed113212313co_ngeed
conjoined1965463conjoined
conned95119703c__onned
consigned1346323consigned
convened143412223convened
cooed84534343co_o__ed
cooeed95917863co_o_eed
cooeyed1346893co_oeyed
cooked135921363co_o_ked
cooled95224583co_o_led
cooped114821603co_o_ped
coopted123710763co_opted
coplotted1444793coplotted
cordoned12229613cordoned
corned95224523c__orned
coronel94515223coro_nel
coroner94218203coro_ner
coronet94227173coro_net
cosigner1135953cosigner
cottoned1138033cottoned
coughed143310903co_ughed
cozened19349183co_zened
crooned103813343c_rooned
crowned133912423c_rowned
doggoned1243883doggoned
ecologies12312353ecologies
eloigned1043423eloigned
eloined8149813_eloined
flogged13528803_flogged
loaned73816293__loaned
logged96622943__logged
longed87121373__longed
maligned1285773maligned
mooned94216643mo_o_ned
ologies8615023_ologies
oologies9312993oologies
pollened1157773pollened
prologed12189193prolog_ed
prologued1344653prologued
prolonged13285403prolonged
reloaned939723reloaned
slogged104910463_slogged
soloed74515743solo__ed
taloned8310223talo_ned
zooned164011083zo_o_ned

Search took 10 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 Limit1461621378.76616673.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.96819925.4
 
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.