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

180 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
conciser1231024(None) 
concise11314471concise_
conceder1338742conceder
conceiver1657412conceiver
concisely1645322concisely
concisest1348252concisest
confider1438122confider
confiner13311192confiner
conifer123212642con_ifer
conniver1337492conniver
consider11310392consider
bonier84321993bon_i_er
bonnier94711313bonni_er
bouncier1236033bounci_er
canceler12238913canceler
cancer104220923canc__er
candider1237343candider
canister101710853can_ister
cannier94014163canni_er
cannister1155723cannister
canvaser13276563canvaser
censer84516583cen__ser
cercises12410933cercises
chancier1538823chanci_er
coacher143714123coac_her
coalier93416183coali_er
coarser93211203co_arser
cobbier133410163cobbi_er
cocinera1245553co_cinera
cocker144320393co_c_ker
cockier154013623co_ckier
codriver1435913codriver
cognise1059683cognise_
cognised1256313cognised
cognises11610043cognises
cognizer2055863cognizer
coiler84421593co__iler
coincide1346493coincide_
coincided1544023coincided
coincides1446433coincides
coiner84323783co__iner
collider113410423collider
collier93618153colli_er
combiner14259723combiner
comfier1439163comfi_er
compiler1438373compiler
composer145012953composer
concave1439373concave_
concaved1636223concaved
concaves1538913concaves
concealer1368223concealer
concede12310103concede_
conceded1438293conceded
conceders1437953conceders
concedes13311063concedes
conceited14310423conceited
conceive1539233conceive_
conceived1746713conceived
conceivers1746313conceivers
conceives1639233conceives
concenter13312213concenter
concern113011963conc__ern
concert113325223conc__ert
conchae143911643conchae_
conches144019813conc_hes
conchie143312683conchie_
conchies153214853conchies
conchs134714903conchs__
concierge1444253conci_erge
conciliar1345923conciliar
concision1348493concision
concluder1444183concluder
concocter1247633concocter
concur10411103conc__ur
concuss1138063concus_s
concussed1444753concussed
concusses1346343concusses
condenser1287413condenser
condoler113412123condoler
condoner112913413condoner
conducer13127373conducer
confer114018683con__fer
confide13310203confide_
confided1537453confided
confiders1537483confiders
confides14310573confides
confine12315583confine_
confined14310403confined
confiners1439953confiners
confines13315653confines
confirmer1665663confirmer
confiteor1443873confiteor
confuse1238853confuse_
confused1437033confused
confuses13310363confuses
confuter1338513confuter
congener112412203congener
conger95024273con__ger
conics103920593conics__
conies84338593con_i_es
conifers133611703con_ifers
coniine9316803coniine_
coniines10415363coniines
conine84528563con_ine_
conines93827803con_ines
conioses10313323conioses
conjoiner1855933conjoiner
conjurer17117683conjurer
conker124721553con__ker
conner84423963con__ner
connive1238993connive_
connived1436433connived
connivers1436933connivers
connivery1744213connivery
connives1339723connives
conquer1838623con_quer
considers1238933considers
consigner1246633consigner
consist9316033consis_t
consisted1238513consisted
consists10310593consists
consoler102812613consoler
conspirer1355293conspirer
consumer1238503consumer
container11311073container
contester11311193contester
continuer1148713continuer
contriver1448343contriver
contuse9311413contuse_
contused1138443contused
contuses10413453contuses
convener132913163convener
converser1438093converser
conveyer16278143conveyer
convincer1645833convincer
convoker17226903convoker
copier103722903co_pi_er
corkier133114303corki_er
cornier93017093corni_er
cosier84423763co_si_er
cottier93814173cotti_er
coucher144515853couc_her
councilor1343203councilor
courier93617893couri_er
courser94114803co_urser
cowier113616163co_wi_er
cowriter13238883cowriter
cozier173315143co_zi_er
crucifer1543683crucifer
cruiser93410433c_ruiser
donniker1333923donniker
exorciser1843743exorciser
fancier123412063fanci_er
focuser12155783fo_cuser
incise83515333_incise_
incised102911583_incised
incises93414893_incises
incisor955323_incisor
inciter93113773_inciter
ionise63516943ion_ise_
ionised82911493ion_ised
ionises72916433ion_ises
ionizer162310123ion_izer
jouncier1734423jounci_er
lioniser845583lion_iser
mincier113512473minci_er
monicker1635733monicker
moniker1338673mon_iker
mortiser1078483mortiser
noncrises11129313noncrises
nonuser7299143non_user
penciler1237113penciler
poetiser1037313poetiser
poiser84217243po__iser
preciser123411663preciser
reconciler1444693reconciler
sonsier7711743sonsi_er
tonier65520713ton_i_er
unwiser1037123_unwiser
wonkier1437423wonki_er

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.420425454.8
2DLD Change Limit1461621807.34619896.8
3Display Results1801800.0762368.4
 (SQL Overall)1786911807.84222786.4
 
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.