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

146 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
coalbin113752(None) 
coalbins1237081coalbins
cabin94820942c_a_bin
calkin123515492c_alkin
coalbox1844102coalbox
coaling103722822coal_ing
coalpit1148502coalpit
codlin94516432codl_in
colin76231692co_l_in
albino839933__albino
algin65718763__algin
aloin55227413__aloin
bobbin93410733bo_bbin
cabbie122913353c_abbie
cabbing143613153c_abbing
cabins104418923c_a_bins
cabling124017553c_abling
cain65643913c_a__in
calcic9311873c_alcic
calcine11315273c_alcine
calif104929103c_al_if
calix145317343c_al_ix
calking144617783c_alking
calkins133814873c_alkins
callan83619603c_allan
calling103826773c_alling
calming123915973c_alming
calpain11310413c_alpain
calving134113503c_alving
cambia124913153c_ambia
caplin103216303c_aplin
carabin11313213carabin
carbine112918643c_arbine
carbon104919043c_arbon
carlin84421823c_arlin
casein83216453c_asein
catkin123512373c_atkin
catlin83819073c_atlin
chablis14368553chablis
chagrin1337883chagrin
chain105723673cha__in
chalcid1537873chalcid
chalking183310063chalking
challie124012853challie
challis124613463challis
chaplain1546193chaplain
coaching164011963coaching
coacting133412693coacting
coaction12310763coaction
coadmit1247823coadmit
coal66939253coal___
coala77521123coal__a
coalas87418963coal_as
coaled95022703coal_ed
coaler84121703coal_er
coalers94419333coalers
coalfish1635493coalfish
coalier93416173coalier
coalify1536683coalify
coalition1148693coalition
coalpits1245393coalpits
coals76129603coal__s
coaly105521593coal__y
coaming123818323coa_ming
coapting133511603coapting
coarsen93210323coarsen
coasting113615503coasting
coati75624633coa_ti_
coating103525303coa_ting
coatis85122593coa_tis
coaxing173511703coa_xing
cobalamin1543503cobalamin
cobaltic1455903cobaltic
cobaltine13135613cobaltine
cobbling15248803cobbling
cobia94117513co__bia
cocain101315013co_cain
cochin131313203co_chin
codein94916713co_dein
codling114418953codl_ing
codlins104116243codl_ins
coffin14339813co_ffin
cohabit1449563cohabit
coiling103723453coil_ing
coin66645353co___in
cojoin1539493co_join
colby124415063co_lb_y
colbys13407153co_lbys
colic95726173co_l_ic
colicin11313743colicin
colins85229043co_l_ins
colleen939533colleen
collie83621993co_llie
collins93419833co_llins
colloid10312873colloid
collying14319543collying
colobi105011083colobi_
colon78630193co_l_on
coloni85619203co_loni
column1038103co_lumn
combine133014723co_mbine
combing143714733co_mbing
complain1448753complain
complin13312073complin
conin76232723co__nin
conjoin1638193conjoin
contain9315823contain
coolie83821603cool_ie
cooling103422573cool_ing
coralline1147943coralline
corban10314693co_rban
corbie103618203co_rbie
corbina111911443co_rbina
cortin82423143co_rtin
coulis84018753coul_is
couloir936143couloir
cousin8517153co_usin
covin105621123co__vin
cowbind1536613co_wbind
cowling134017413cowl_ing
cowskin1645553cowskin
coxalgia1842743coxalgia
coxalgic2043023coxalgic
crabbing15287933crabbing
cyanin113911453cya_nin
cyclin1339273cycl_in
cymlin1337313cyml_in
dobbin11339523do_bbin
foaling113515843foal_ing
folacin1238053folacin
goalie7413153goal_ie
goaling93515333goal_ing
goblin939503gobl_in
hoatzin1943913hoatzin
hyalin122210033hyal_in
kaolin1039583kaol_in
malkin122913143_malkin
moulin8313283moul_in
olein5316003_o_lein
poplin10413483popl_in
rabbin103112303_rabbin
robbin103611183ro_bbin
robin74820283ro__bin
sabin74924953_sa_bin
solanin7311943solanin
woodbin1354873woodbin

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271467.76617258.2
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.95222471.2
 
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.